How to implement slowly change dimension..

helpmeout · Post by **helpmeout** » Thu Nov 02, 2006 3:55 pm

Hello All..
can somebody tell me how slowly change dimension will be implement in datastage using different processing stage..
thnks..

nelab28 · Post by **nelab28** » Thu Nov 02, 2006 4:05 pm

Well, What type of slowly changing dimensions are you looking at ?.

Have a look at the documentation for Change Capture Stage, to get the differences between datasets. And based on the code returned from the change capture stage, have subsequent jobs to delete, insert/update based on the surrogate key.

If you have a more clear query, help would be more to the point.

helpmeout · Post by **helpmeout** » Thu Nov 02, 2006 4:30 pm

Thnks..
but i m asking for type-2
ok thnks..bye..

ray.wurlod · Post by **ray.wurlod** » Thu Nov 02, 2006 7:36 pm

Search is your friend. Do you think you were the first to ask about slowly changing dimensions?

tagnihotri · Post by **tagnihotri** » Mon Nov 06, 2006 6:58 am

I will say wait for HAWK!! I heard it is having SCD (slowly changing demention) stage itself

DSguru2B · Post by **DSguru2B** » Mon Nov 06, 2006 7:37 am

True, there is an SCD stage in DataStage 8.0, but its not that hard to implement. As Ray pointed out, search this forum or even google to get the pseudocode. Then turn that into computational logic by use of different stages.