Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have 3 different fact table and 3 dimensions, one for each fact table, that contains same data type. How can i merge this 3 dimensions in one only dimension as calculated dimension?
Thanks a lot
If the dimension-tables contain nearly the same they could be relative easy concatenated:
dimAll:
Load * From dim1;
concatenate
Load * From dim2;
concatenate
Load * From dim3;
But to handle 3 different fact-tables within a single datamodel isn't quite easy. Maybe these links are helpful:
Fact Table with Mixed Granularity
Data Modelling: Clarity vs. Speed
Merging Data from Multiple Sources
- Marcus