Hi, can someone please help or point me in the right direction for the following:
I have to import 6 tables with transactions from 6 different SQL databases. Each table has exactly the same headings. Before I can use these tables I have to unpivot the same columns in each of the tables.
My question is, is it better to have 6 different transaction tables with similar measures linked to a single calendar table or should these tables be appended to one another. Is there a sound argument for either of the methods ?
Thanks
P
I have to import 6 tables with transactions from 6 different SQL databases. Each table has exactly the same headings. Before I can use these tables I have to unpivot the same columns in each of the tables.
My question is, is it better to have 6 different transaction tables with similar measures linked to a single calendar table or should these tables be appended to one another. Is there a sound argument for either of the methods ?
Thanks
P