Data Warehouse Type 2 slowly change dimension in kettle
In kettle, we can implement type 2 slowly change dimension easily by using “Dimension lookup/update”. We have below table in a CSV file: COUNTRY_ID,COUNTRY_NAME,REGION,LAST_UPDATE_DATE 11,Baharian,A,2015-02-15 12,China,Beijing,2013-02-15 13,USA,AZ,2014-02-20 14,CUBA,CIUDAD,2011-02-19 15,USA,Los Angeles,2011-02-18 16,Japan,TOKYO,2011-02-15 We want to put into table with below structure: First, we have 2 elements: Text file input, Dimension lookup/update. Text file input configuration: Dimension… Read More »