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
last update timestamp logic on SCD stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 44
- Joined: Wed Sep 02, 2015 7:19 am
- Location: Brasilia, Brazil
last update timestamp logic on SCD stage
Leandro Vieira
Data Expert - Brasilia, Brazil
Data Expert - Brasilia, Brazil