last update timestamp logic on 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
leandrohmvieira
Participant
Posts: 44
Joined: Wed Sep 02, 2015 7:19 am
Location: Brasilia, Brazil

last update timestamp logic on SCD stage

Post by leandrohmvieira »

Greeting experts.

We are migrating some dimension jobs made in server job to parallel jobs.

On Dimension tables there is a field called "LAST_UPDATE_DATE" which enters as null for new dimension rows and is filled with current timestamp when a type 1 update occurs.

How do i implement this logic on SCD Stage? There is a way to check if a row is getting a type 1 update?

Thanks in advance
Leandro Vieira

Data Expert - Brasilia, Brazil
Post Reply