REG SCD 1 IN Px

raju4u · Post by **raju4u** » Mon Jun 14, 2010 3:36 am

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 ...

chulett · Post by **chulett** » Mon Jun 14, 2010 6:04 am

We cannot as you have not stated the problem you are having.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 14, 2010 5:37 pm

We can. Overwrite the record.

vmcburney · Post by **vmcburney** » Mon Jun 14, 2010 7:13 pm

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.

chulett · Post by **chulett** » Mon Jun 14, 2010 7:57 pm

ray.wurlod wrote:We can. Overwrite the record.

I think we're more into the how than the what, Ray.

agpt · Post by **agpt** » Mon Jun 14, 2010 10:51 pm

depends on which version of data stage you are.

if you are on 8.1 , you can use in built SCD stage.