Hi all,
I have a problem regarding surrogate key, do we have any option in data stage to generate a surrogate key on the basis of some key coloum which are the part of unique primary index.
records may come with same combination of those columns ,all those record should have the same surrogate key.
thanks
kamal
Surrogate key Generation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Thu Oct 26, 2006 12:47 am
- Location: chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Of course you have that option. But can you guarantee uniqueness if you're only using part of the primary key? If not, the proposed course of action makes no sense.
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.