abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Mar 30th, 2010

 

Yes, we can implement SCD types in ABInitio while using assign keys concept by implementing natural keys as well as surrogate keys implemantation.

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Apr 6th, 2010

 

sorry the before answer is wrong.we can work out the scds with redefining the formats

sudheer_abinitio

 Profile Answers by sudheer_abinitio 

• Jun 8th, 2010

 

We phase 3 types of SCD.

1. SLOWLY CHANGES DIMENSION TYPE 1 
    Having the current data. Latest data. Ex: 1 Record only

2. SLOWLY CHANGES DIMENSION TYPE 2 
    SCD type to having the history data.. This is very useful to data process, ex : 1 to n records 

3. SLOWLY CHANGES DIMENSION TYPE 3 
    Partially contains the data .. 
    Current prior data 1,2 records only