I have data source in which multiple tables are prese3nt , and all tables have lot of columns (Approx. 200) in each table . And about 100 column names are same in the tables.
So to remove the synthetic key I can do the following solution :
1 : Renaming the field
2 : Using Qualify Function
But renaming fields is not a good option it will take lot of time .
And Client requirement is , not to use the qualify function.
So can you all suggest me any other way to do this .
