I'm new to talend and new to the community.I want to capture the history of particular attributes something like we do SCD type3, but with more than a single level of history. please help me with your expertise how can I achieve it with talend.
I've data something like this
and I want store history like below
after first change it must look like this (change are region = East )
after second change it must look like this (change are region = North and state=HR)
Solved! Go to Solution.
Thanks Sir, for such a quick reply and it's almost what I needed but you don't considered the when only state may be changed not the region and it have to store the history just for the state and region should be null as region is not changed so no value will be entered in previous_lvl1_region
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables