Saturday, March 28, 2015

ODI SCD TYPE 3 (Slowly Changing Dimension) Implementation in ODI.

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.




ODI SCD Type 2 Implementation step by step process, Oracle Data Integrator Interface example for implementing Slowly changing dimension Type 2.


ODI SCD Type 2 Implementation step by step process,
Oracle Data Integrator Interface example for implementing Slowly changing dimension Type 2.



Thursday, March 5, 2015

What is Multi-connection IKM ? And When its required?

What is Multi-connection IKM ? And When its required?

In interfaces if you are using staging area different from target like other databases or internal memory engine that time we need Multi -connection IKM, Oracle providing some of multi connection IKM's like 
1) IKM sql to sql control append
2) IKM sql to sql incremental update
3) IKM sql to file append .....

if we are not selecting multi connection ikm  we need to select Two LKM's
1) one LKM for source to staging 
2) 2nd LKM for staging to target staging (again it will create staging in target)