Page 1 of 1

usage of slowly changing dimensions in datastage

Posted: Thu Mar 31, 2005 10:39 am
by shivajid2k
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

Posted: Thu Mar 31, 2005 11:09 am
by mhester
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,

Posted: Thu Mar 31, 2005 12:56 pm
by DSguru2B
Gota go through DataStage basics.
What type of SCDs you want to implement?

Posted: Thu Mar 31, 2005 4:36 pm
by ray.wurlod
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.

Posted: Mon Apr 04, 2005 2:29 pm
by arun_im4u
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).