Hi Anyone know how to implement type 2 slowly changing dimensions in datastage.
Thank you
NOTE : [I]This question was asked by v_wich, I am posting it in proper forum][/i]
Printable View
Hi Anyone know how to implement type 2 slowly changing dimensions in datastage.
Thank you
NOTE : [I]This question was asked by v_wich, I am posting it in proper forum][/i]
It might just be the same as to what other tools do. Adding up one filled in a record identifying the current and the previous record. Have you heard of mini dimension ? try it before using the SCD2
ERRATUM: adding a filled --- FIELD or column I mean.