SCD stage implementation samples in DS 8.0(Hawk)

vinayc · Post by **vinayc** » Mon Dec 10, 2007 3:37 am

Hi,
Currently i am working on SCD stage in DS 8.0. But I am facing the problems of setting the purpose codes. I want to implement the Type 2 SCD. The purpose code 'Expiration date' can have the Expires derivation but I am not getting the correct method to specify it.
Has anyone implemented this before?? I just want to know the samples implementation.
Can anyone help me on this??

vmcburney · Post by **vmcburney** » Mon Dec 10, 2007 5:50 pm

There is a presentation on the SCD stage at the LeverageInformation site. The link is in my blog post 7 Even Better Online DataStage Tutorials. It shows a demonstration of using the stage.

vinayc · Post by **vinayc** » Mon Dec 10, 2007 8:53 pm

Thanks a lot Sir.
It will help me a lot.

vinayc · Post by **vinayc** » Wed Dec 12, 2007 3:51 am

vmcburney wrote:There is a presentation on the SCD stage at the LeverageInformation site. The link is in my blog post [url=http://blogs.ittoolbox.com/bi/websphere ... torials-20 ...

Hello,
I used all the steps given in that presentation about SCD. But rather than updating a row with expired condition, it is inserting a new blank row having only expired condition (eg: CurrentDate())
Can you please help me on this issue?

vmcburney · Post by **vmcburney** » Wed Dec 12, 2007 5:06 pm

Not sure I understand you. Are you trying to expire a dimension row? You would need to close out the existing dimension row setting end date to current date. You then need to decide whether to leave it at that or insert a new row with a status of expired and a high end date. I'm not sure the best method of expiring a dimension in SCD 2.

vinayc · Post by **vinayc** » Thu Dec 13, 2007 8:47 pm

vmcburney wrote:Not sure I understand you. Are you trying to expire a dimension row? You would need to close out the existing dimension row setting end date to current date. You then need to decide whether to leav ...

Hello,
I have done the same thing. Iam trying to expire a dimension row with the current date. But it is not getting updated.