Hi
I'm using @OUTROWNUM variable to generate surrogate keys...and I entered my records in the Oracle table. When i try to insert a new record i've to find the max surrogate key generated and include this in the derivation with an increment.
How can I do this!
Thank You
Surrogate Key
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 53
- Joined: Wed Nov 05, 2003 8:36 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can certainly do this. There are many techniques, you can search for them on the Forum.
Then again, you may not need to. If the target database supports serial data type, or sequences, then you can have the surrogate keys generated when inserting rows into the dimension tables.
Then again, you may not need to. If the target database supports serial data type, or sequences, then you can have the surrogate keys generated when inserting rows into the dimension tables.
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.
-
- Participant
- Posts: 53
- Joined: Wed Nov 05, 2003 8:36 am
Do a search and you will definetly find some thing to get going.
Here is a good one.
This should get you going.
Siva.
Here is a good one.
Code: Select all
http://dsxchange.com/viewtopic.php?t=86052&highlight=openpath
Siva.