Hi,
Hope this helps.
I've created two tables TEST1 and TEST2, Both the tables contain 3 columns. to create an association between two tables we would need one common column in both the tables. However there are situations where there are more than one columns that have same names in both the tables. e.g below.
TEST1:
LOAD
A,
B,
C
RESIDENT TABLE_A;
TEST2:
LOAD
A,
B,
D
Resident TABLE_B;
A and B columns will create a synthetic key between the two tables here. To avoid this, i can rename a column from any one of the tables for which i do not want any association. Like say,
TEST1:
LOAD
A,
B,
C
RESIDENT TABLE_A;
TEST2:
LOAD
A,
B AS TEMP_COL,
D
Resident TABLE_B;
Now the tables will be associated with only the A column.
