Dimension Merge

[#1]

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

[marcus_sommer]

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

Concatenate vs Link Table

Merging Data from Multiple Sources

- Marcus