ODI SCD TYPE 3 (Slowly Changing Dimension) Implementation in ODI.
Step1: Create duplicate on update existing rows in IKM Oracle Incremental update and change that code like below
step2: In interface prev_Sal column deselect INSERT and UPDATE and Select UD2 option in quick edit as well as select CUR_SAL UD1.
Step1: Create duplicate on update existing rows in IKM Oracle Incremental update and change that code like below
step2: In interface prev_Sal column deselect INSERT and UPDATE and Select UD2 option in quick edit as well as select CUR_SAL UD1.
No comments:
Post a Comment