DSXchange

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

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

We can. Overwrite the record.

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.

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

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

depends on which version of data stage you are.

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