Slowly changing dimensions and DSSCD routines

kstrigun · Post by **kstrigun** » Thu May 15, 2008 6:01 am

Does any one know how to use the datastage routine DSSCD and/or the SCD2 Transform. I cant seem to find any documentation on these. I'm trying to find some examples on how to set up one that uses slowing changing dimensions to handle changes to our customer dimension.

Thanks

ray.wurlod · Post by **ray.wurlod** » Fri May 16, 2008 4:57 am

Can you please check to determine whether this routine was written in-house at your site? I don't have it on my system. The same is true of the "SCD2 Transform". What is its provenance?

kstrigun · Post by **kstrigun** » Fri May 16, 2008 7:40 am

No one at my site has any recollection of these so I'm under the impression they came with 7.5

These are located under Routines / DS / SCD and under Transforms / SCD

ray.wurlod · Post by **ray.wurlod** » Fri May 16, 2008 7:44 am

Not on any 7.5 system with which I've worked.
Nor do these categories exist.

They've come from in-house or from some consultant you've used. Can you look at the documentation (General or Version tab) to see whether they've admitted to authorship?

kstrigun · Post by **kstrigun** » Fri May 16, 2008 7:52 am

Ok, that's a good idea, Thanks for your help. I'll close this topic