Question On Conformed Dimension design
Page 1 of 1
Question On Conformed Dimension design
After reading Kimball's section on Conformed dimensions and making some changes in my project, I have question related to design.
I have a "Person" dimension that is used in 4 different fact tables. I am creating a fifth fact table for Claim Payment information where there is a claim associated to each claim payment.
The OLTP database structure looks like the following
Person One to Many Claims One to many ClaimPayments
When I bring the data into the warehouse, I have a key directly from Person to claim payment And then Claim directly to claim payment.
By adding the PersonName and Social Security Number to the Claim table I can know which person exists without having to snowflake.
My question is, is the above duplication of columns in two different dimensions usually the way conformed dimensions are used and are they preferred over an outrigger that leads to small snowflaking ? I can see many of my dimensions having duplicate data in order to avoid snowflaking I have kept the column names identical but still not sure if this is the correct way for not joining dimensions but being able to identify relationships between them without fact table joins.
I have a "Person" dimension that is used in 4 different fact tables. I am creating a fifth fact table for Claim Payment information where there is a claim associated to each claim payment.
The OLTP database structure looks like the following
Person One to Many Claims One to many ClaimPayments
When I bring the data into the warehouse, I have a key directly from Person to claim payment And then Claim directly to claim payment.
By adding the PersonName and Social Security Number to the Claim table I can know which person exists without having to snowflake.
My question is, is the above duplication of columns in two different dimensions usually the way conformed dimensions are used and are they preferred over an outrigger that leads to small snowflaking ? I can see many of my dimensions having duplicate data in order to avoid snowflaking I have kept the column names identical but still not sure if this is the correct way for not joining dimensions but being able to identify relationships between them without fact table joins.
mru22- Posts : 34
Join date : 2011-06-14
Similar topics
» Conformed Dimension Question
» Conformed dimension design
» FACT Design Question - How to design FACT Table when computation is required on the degenerate dimension?
» Dimension design question
» Dimension Design Question
» Conformed dimension design
» FACT Design Question - How to design FACT Table when computation is required on the degenerate dimension?
» Dimension design question
» Dimension Design Question
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum