Hi all....
How to implement the slowly changing dimension type 3 in Data stage 7.x...
if possible give me one example....that is great help for me...
Thanks
Kumar G
How to implement the SCD type 3 in Datastage 7.0 ...
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 4
- Joined: Thu Apr 08, 2004 7:28 am
1. Read the source row.
2. Transform the souce row.
3. Reference the row in the target table (either prestage to hash or do OCI lookup)
4. Update all non-SCD type 3 columns if they are different.
5. Compare SCD type 3 columns against their current value. If different, then move version 3 value to version 4 value, version 2 value to version 3 value, current value to version 2, and new value into the current column. Repeat this for all SCD type 3 columns.
6. If any columns were updated, load the row into the target.
2. Transform the souce row.
3. Reference the row in the target table (either prestage to hash or do OCI lookup)
4. Update all non-SCD type 3 columns if they are different.
5. Compare SCD type 3 columns against their current value. If different, then move version 3 value to version 4 value, version 2 value to version 3 value, current value to version 2, and new value into the current column. Repeat this for all SCD type 3 columns.
6. If any columns were updated, load the row into the target.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Which is it, 6x or 7x?
Do you know how to update an existing record with new information? Not really all that different. Pull all existing relevant information into a Hash and use it as a Reference Lookup. Insert or Update from there.
How much of an 'example' do you need? Is that enough to get you going? I'm assuming you know what a Type 3 Dimension is, it's just the DataStage part you need help with...
If you do need more help, there's always Ken's post. Me too slow.![Laughing :lol:](./images/smilies/icon_lol.gif)
![Wink :wink:](./images/smilies/icon_wink.gif)
Do you know how to update an existing record with new information? Not really all that different. Pull all existing relevant information into a Hash and use it as a Reference Lookup. Insert or Update from there.
How much of an 'example' do you need? Is that enough to get you going? I'm assuming you know what a Type 3 Dimension is, it's just the DataStage part you need help with...
If you do need more help, there's always Ken's post. Me too slow.
![Laughing :lol:](./images/smilies/icon_lol.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
If you want an example just upgrade to 7.1 and use the intelligent assistant, it can be used to create a set of example jobs for you. From memory I don't think this assistant was in the 7.0 release.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn