Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am facing the new problem as there is presence of synthetic key how can i solve this?
Hi,
Rename that field or make the composite keys based on this keys.
Ex:-
Tab1:
Load
A
From Location;
Tab2:
Load
A as Tab2A
From Location;
You can use the qualify statement as well.
Regards,
Anand
A synthetic key is not necessarily a problem. Read this blog post first: Synthetic Keys
see these, helpful for you: