SLOWLY CHANGING DIMENSION TYPE 2 IN DATASTAGE PARALLEL JOBS
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 57
- Joined: Tue Jun 30, 2009 9:38 am
SLOWLY CHANGING DIMENSION TYPE 2 IN DATASTAGE PARALLEL JOBS
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