Q:

Fact Constellation Schema

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.

A:

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

