Hi everybody,
I have a little tricky case:
Data can be valid on the basis of a month. So a record can be valid from 01.03.2013 to 31.12.2999 for example.
CASE 1: changes in the same month of date_from
If the record is created in March for example (date_from: 01.03.2013) and changes are made in the SAME month (March), then there should only be an update of the record (like SCD1).
CASE 2: changes in another month than date_from
If the record is created in March for example (date_from: 01.03.2013) and changes are made in April, then
* the old record is updated to date_to 31.03.2013
* a new record is created with date_from 01.04.2013
(like SCD2)
Do you have any ideas to solve this in an "appropriate way"?
Best regards,
Kerstin
SCD2 on the basis of months
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Split the job into two streams based on the date rule, run the data through SCD stage with properties appropriately set on each stream.
Last edited by ray.wurlod on Tue Oct 29, 2013 3:26 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.