Linking key columns

yaminids · Post by **yaminids** » Fri Oct 22, 2004 4:49 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Oct 22, 2004 5:04 pm

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".

yaminids · Post by **yaminids** » Mon Oct 25, 2004 11:24 am

Hi,
Thank you very much for your help.
-Yamini

DSXchange

Linking key columns

Linking key columns

Re: Linking key columns