scd with surrogate key

[rsunny]

Hi every one,

Can anyone tell me the process of implementing scdtype1 and scdtype2 using Surrogate key.

Thanks in advance

[ray.wurlod]

Yes, but why not find it yourself, perhaps via an Internet search? There are volumes and volumes written on the topic, and some differing opinions about what's "best".

Or are you specifically asking about how to manage surrogate keys in DataStage server jobs? That usually involves using one of the surrogate key management routines, or relying upon a database sequence for their generation, depending on other factors such as whether the target table is being updated at the same time by non-DataStage processes.