last update timestamp logic on SCD stage
Posted: Mon Dec 12, 2016 7:59 am
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
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