Need of SCD stage in datastage

karthi_gana · Post by **karthi_gana** » Fri Mar 02, 2012 11:36 pm

All,

I have visited the below URL and read about SCD and its types.

http://etl-tools.info/en/datastage-tuto ... astage.htm

I don't see SCD stage in any types. i.e 1,2,3 and 4. They have implemented all those types without using SCD stage. It makes sense for me.

They have implemented all the SCD types with the help of sequential, hashed and ODBC stage. why do we need SCD stage ? what is the advantage of using that? may be the surrogate key & business key add some value for this stage. right?

It seems like datastage SCD stage supports only SCD1 & SCD2. right?

if i want to implement SCD3 or SCD4, i have to go with sequential, hashed and ODBC stages. right?

Inputs are welcome!

ray.wurlod · Post by **ray.wurlod** » Sat Mar 03, 2012 1:54 am

SCD stage supports only Type 1 and Type 2 (and "Type 1 and a half" if you follow that nomenclature). It's probably because there's yet to be industry agreement on what Type 3 and Type 4 actually mean that support for these is not provided in the SCD stage.

chulett · Post by **chulett** » Sat Mar 03, 2012 9:18 am

Keep in mind that site just publishes material ripped off from official sources and that is the old tutorial from the 7.5 Server release, hence no mention of any PX stages.