Thanks Rupam. I am afraid I am too new to understand your answer .
Can you please advise what a common date table is? a table that only includes dates? can you share an example?
If i create such a table and associate the salary dates and the sales dates with it, should it solve the circular reference? they will both still be associated to each other by the date via a third table.
What do you mean by concatenating sales and salary into a fact table? should i join both tables together? can i do it in the script as i would like to keep the source files as they are. If so, could you please point me in the right direction for creating the appropriate syntax?
sorry for all the questions and thanks for your help!