suganyasug

• Apr 18th, 2007

 

We can implement SCD in datastage
1.Type 1 SCD:insert else update in ODBC stage
2.Type 2 SCD:insert new rows if the primary key is same and update with effective from date as JobRundate and to date to some max date
3.Type 3 SCD:insert value to the column the old value and update the existing column with the new value

vijay

• Nov 4th, 2007

 

 by using lookup stage and change capture stage we will implement the  scd.
   we have 3 types of scds
   type1:it will maintain the current values only.
   type2: it will maintain the both current and historical values.
   type3: it will maintain the current and partial historical values.