Defining SCD Type at the record level
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 26
- Joined: Tue May 24, 2005 6:20 am
- Location: Tallahassee
Defining SCD Type at the record level
I'm in the process of finalizing a dimension loading process following Kimball's methodology. I have a question that may change my process. What's the affect of treating the whole record as Type 1 or Type 2 instead of individual columns on a record?
Byron
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
-
- Premium Member
- Posts: 26
- Joined: Tue May 24, 2005 6:20 am
- Location: Tallahassee
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 26
- Joined: Tue May 24, 2005 6:20 am
- Location: Tallahassee
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 26
- Joined: Tue May 24, 2005 6:20 am
- Location: Tallahassee
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The DataStage logic is exactly the same as the "logical logic". If a field is a candidate for recording change, then a new record must be created whenever there is a change in that field. Therefore, you must determine whether a change has occurred. This involves being able to see (pre-load) what's already current in the target table, and to test for change in every candidate field.
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.