CODEWITHSUNDEEP
data-warehouse
Zinx
Zinx

Reputation: 2349

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.

Upvotes: 2

Views: 2844

Answers (2)

bugrasitemkar
bugrasitemkar

Reputation: 461

I know it's been a while just writing to help if any other people needs information about this topic. Normally fact constellation model is made up of star models where any artifical or natural hierarchy should not be present. But according to your needs you can add normalized (hierarchical) dimension tables. In this case your fact constellation made up of snowflakes instead stars.

Upvotes: 2

Jit
Jit

Reputation:

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

Upvotes: 1

Related Questions