Question about onformed Dimension
5 posters
Page 1 of 1
Question about onformed Dimension
Hi,
I have product Dim, Time Dim and customer Dim tables in Sales data mart and Inventory data mart. These 3 are conformed dimension, but, does it mean that I should not store additional attributes like "product start date" and "product expiry date" in the same PROD_DIM table? should I got for a PROD_DIM history, inorder to maintain the conformed dimension on PROD_DIM?
Thanks,
DW Beginner
I have product Dim, Time Dim and customer Dim tables in Sales data mart and Inventory data mart. These 3 are conformed dimension, but, does it mean that I should not store additional attributes like "product start date" and "product expiry date" in the same PROD_DIM table? should I got for a PROD_DIM history, inorder to maintain the conformed dimension on PROD_DIM?
Thanks,
DW Beginner
DW_Beginner- Posts : 1
Join date : 2009-11-15
Re: Question about onformed Dimension
sounds like a type 2 slowly changing dimension, with a start and end date for the range the row is valid.
You should also include a currently valid boolean flag to speed operation.
You should also include a currently valid boolean flag to speed operation.
Re: Question about onformed Dimension
A dimension is conformed if the context provided by the dimension is applicable to all facts that use it. Does the addition of these attributes materially affect the context the dimension, or does it mearly add additional information not provided before?
Re: Question about onformed Dimension
Questions are too good really good questions keep it up guys.
smithcarter210- Posts : 2
Join date : 2011-05-12
Age : 39
Re: Question about onformed Dimension
You are right Mr smith carter.
samueljohnson481- Posts : 1
Join date : 2011-05-22
Similar topics
» Question on breaking out Degenerate Dimension to separate dimension
» Question about using date dimension keys in other dimension tables
» Dimension Question
» Fact Dimension question
» Dimension Design Question
» Question about using date dimension keys in other dimension tables
» Dimension Question
» Fact Dimension question
» Dimension Design Question
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|