usage of slowly changing dimensions in datastage

shivajid2k · Post by **shivajid2k** » Thu Mar 31, 2005 10:39 am

hai,

I am now using Datastage 6x version. I need to know how i can use slowly changing dimensions in Datastage.

thanks in advance

Siva

mhester · Post by **mhester** » Thu Mar 31, 2005 11:09 am

I believe you can do a search for SCD, or Slowly etc... and find a bunch of information regarding the implementation of SCD's within DS. I believe Ken and others have given wonderful discourse on how to do this.

Regards,

DSguru2B · Post by **DSguru2B** » Thu Mar 31, 2005 12:56 pm

Gota go through DataStage basics.
What type of SCDs you want to implement?

ray.wurlod · Post by **ray.wurlod** » Thu Mar 31, 2005 4:36 pm

The good news is that all types can be accommodated.

However, please do search the forum; it has been covered previously.

A really friendly gesture would be to reply to this thread with links (use the URL button) to the answers you find.

For example here is one post on SCD technique in DataStage.

arun_im4u · Post by **arun_im4u** » Mon Apr 04, 2005 2:29 pm

Ur question is not very specific. But slowly changing dimensions can be done using a hashed-file ( look-up stage) or at the simplest level by just writing into a file(by setting the option to update).