Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Its nothing but Combining the common fields which makes synthetic keys
Ex:
Tab1:
Load
Country,
Region,
Sales,
Products
From --------------;
Tab2:
Customer,
Outstanding
From ---------------;
If you load these 2 tables directly your script contains synthetic keys (Country and Region-- common in both tables)
Sol:
Country&'-'&Region as Key //Composite key
Sales
View solution in original post