Page 1 of 1
SCD type3 in DS 8.0
Posted: Tue Jul 31, 2007 1:22 am
by prasad_chennai
Hi,
Can anyone suggest me how to proceed with SCD type 3 in DS 8 parallel with the help of a scenario?? I have seen that there is a current indicator option in scd stage but dont have a clue what to do with it??
Please help.
Re: SCD type3 in DS 8.0
Posted: Sun Feb 10, 2008 8:29 pm
by cetzhbo
prasad_chennai wrote:Hi,
Can anyone suggest me how to proceed with SCD type 3 in DS 8 parallel with the help of a scenario?? I have seen that there is a current indicator option in scd stage but dont have a clue what to do with it??
Please help.
I thought current indicator is used for scd type 2, which for latest value is 'Y', else for old value is 'N'. can anyone help to denote how to implement type 3 scd using this new stage type "scd stage"?
Posted: Tue Feb 12, 2008 12:28 am
by vmcburney
There si a video on how to use the SCD stage over at the LeverageInformation website that might help you. See
7 Even Better Online DataStage Tutorials for details.
Posted: Wed Feb 13, 2008 2:09 pm
by Aruna Gutti
I just attended a dataStage Essentials V8 DX444 class and as per the discussions in the class the current SCD stage can not be used for type 3 dimensions.