Hi,
I would like to know how to implement the scd type 1 in px.
my requirement is as follows
source is dataset with three coloumns and 1 coloumn is key coloumn and i am using the lookup stage and my reference stage db2.
i am doing the lookup on one key coloumn and i am updating the fields whtever we have in the source to the target table,for the matched rows i need to update the 2 coloumn in the target table.
Please help me ...
REG SCD 1 IN Px
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Have you considered using the Slowly Changing Dimension stage that comes with DataStage 8.1? It may make the process easier for you to build since it handles the surrogate key column and the insert/update commands of a Type 1 dimension.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn