Fact Constellation Schema

Question

Hi All,

I made a fact constellation schema with 2 fact tables and 16 dimension tables with 4 common dimension tables. One of the dimension table needs to be normalized because data from data source can have variable number of rows. Can I still call it fact constellation schema having a branch in dimension table??

I hope you understand what I am trying to say.

Cheers.

Answer 1

Hi Mohammed, You may still call it a Constellation Schema with Sliced Dimension Table. This term is very much in Oracle Datwarehosing Book which I read around 7 years ago.

Regards, Jit