synthetic key

[ssriramin19]

Hi,

      I have two tables  A and B.Table A has 10 columns and table B has 10 columns .The columns names are same in both the tables. Because of the same column name synthetic key is getting formed.

Can anyone tell me how to resolve the synthetic key that is being formed

Thanks

Sriram

[#2]

Hi Sriram,

TABLE A    TABLEB

COL1          COL1

COL2          COL2

COL3          COL3

.....               ....

.....               ....

COL10        COL10    

Before Load, give Qualify and Unqualify keywords

QUALIFY * ;

UNQUALIFY COL1 ;

[#3]

"Combined key" >< syn. key  ???