My idea would be to use the Qualify statement.
Then all fields get the name of the table added which makes them unique
before the upload Qualify *;
Sales (becames Table1.Sales)
Location (becames Table1.Location)
Sales (becames Table2.Sales)
Location (becames Table2.Location)
All you have to concentrate on is to make sure no two field in a table are linked to a same dimension table.There should only be one field association between two tables to avoid synthatic keys. To achieve this make sure all the fields which need not be linked , are named uniquely. I would suggest you to go through this article for more information: