CODEWITHSUNDEEP
database-designdimensional-modeling
Siddharth
Siddharth

Reputation: 67

Comments, Notes in Dimensional data modeling

Project DimensionI am working on creating dimensional model for real estate project and purchase order data which undergoes multiple approvals, there are multiple comments and notes also for each of the projects. In my design, I have considered grain of the fact table as purchase order line item. I am considering Project as a dimension and had to create snowflake tables for approval, comments, and notes. Since the approval, comments and notes are not directly associated to a purchase order. I am not sure if there is a way to avoid snowflake tables here. Please share your suggestions. Many thanks.

Upvotes: 1

Views: 897

Answers (1)

Ron Dunn
Ron Dunn

Reputation: 3078

I don't know your fact table/s, but to handle this scenario I'd create a fact like Activity, with dimensions of Project, Date, ActivityType (ie, Approval, Note, Comment) and the comment value as the "measure".

This type of table, with non-numeric measures, is often referred to as a "factless fact".

Upvotes: 1

Related Questions