SLOWLY CHANGING DIMENSION TYPE 2 IN DATASTAGE PARALLEL JOBS

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bhargav_dd
Premium Member
Premium Member
Posts: 57
Joined: Tue Jun 30, 2009 9:38 am

SLOWLY CHANGING DIMENSION TYPE 2 IN DATASTAGE PARALLEL JOBS

Post by bhargav_dd »

HI,Can anyone please suggest me the procedure to implement a TYPE 2 SCD in Parallel jobs although I am familiar with server jobs SCD2, where the changed columns are updated and the new columns are inserted and also new rows for the Effective Date column and Expiry date column are created or say version or flag etc are done solely using a Server Transformer where we can perform a LOOKUP, Mention the Constraints as well as the Derivation for the Date columns(Effective date column and Expiry Date column). But I am unable to achieve the same purpose Using the PARALLEL jobs. The changed rows are Extracted giving a reject link using a LOOK UP STAGE or even by using the CDC, but I am unable to get these changed rows updated into the Target orInsert new Effective and Expiry date columns I am struck on this job. Help me out clan Ascential- Regards
Post Reply