creating surogate key
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Thu Dec 28, 2006 1:39 am
creating surogate key
please help me in getting the steps to generate surrogate keys using the user_id and the planname column.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please help us to help, by supplying more information, not least of which are the data types of these two fields and whether they form a key. The fact that these are meaningfully named suggest that you need another column which will act as the surrogate key. What is its data type (usually integer of some kind)? What stage type are you envisaging using?
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.