Data Stage and Slowly Changing Dimensions

[monsky]

Hi guys,

I'd like to know if Data Stage has the ability to handle Slowly Changing Dimensions? I'm not sure of this but when I went to their site they seem to use Cognos Decision Stream as an add-on to handle this. Can you guys confirm this?

 

[BocaBurger]

Since DS runs in batch mode, any change to data should be reflected in the next run, if I understand your question.

What are your trying to do? What is the data source?



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!

 

[johnherman]

As far as I know, SCD's must be coded manually in Data Stage - there is no check box to handle this automatically.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright