Need Help on Record insert and update for SCD Stage

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
syang@collaborative.com
Premium Member
Premium Member
Posts: 33
Joined: Tue Sep 02, 2014 7:43 am

Need Help on Record insert and update for SCD Stage

Post by syang@collaborative.com »

Hi guys,

I am working with the Slowly Changing Dimension Stage, and I am trying to write some logic for a Record Update Date. These are the requirements:

If the record is not current, the record update should never be updated.
If the record is current, and the update is a Type2, then the record update date will update.
If the record does not exist, insert the record and set the record update date to NULL.

Is there an easy way to update the record update date only when a Type1 update is used?
Post Reply