In My Datamodel i have two tables one table contains the sales represent details the second table contains sales represent performance details the thing is 4 fields common between both tables when i load the data and then run synthetic table was formed
to remove that synthetic table which approach is best
1.join two tables or
2.by using qualify for three fields except key field or
3.remove common fields from one table except key field
I would go with 1st or the 3rd option. If key fields repeat in any of the two tables, I would stick with 3rd option, else there is no harm in joining them together too. I don't see a benefit of Qualifying them and creating another field with the same information available in another field.