Hello there,
I am trying to link surrogate key column of table A to a column in table B. My intension is to link these two columns in the sense to make column in table A as a foreign key which refers to the column in table B. I hope I am clear with my problem. Can anyone explain to me how to accomplish this.
Thanks in advance.
-Yamini
Linking key columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Pre-load a hashed file with the natural (business) key as the hashed file key and the corresponding surrogate key value as the non-key column.
Use this hashed file to perform your "reverse lookup".
Use this hashed file to perform your "reverse lookup".
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.
Re: Linking key columns
Hi,
Thank you very much for your help.
-Yamini
Thank you very much for your help.
-Yamini