Dimension with Surrogate key of other dimension
3 posters
Page 1 of 1
Dimension with Surrogate key of other dimension
Can one dimension store surrogate key of another dimension?
e.g. Prodcut Dim with Surrogate key of Product Type Dim
If so, is it good practice to have such kind of modelling?
e.g. Prodcut Dim with Surrogate key of Product Type Dim
If so, is it good practice to have such kind of modelling?
user2000- Posts : 2
Join date : 2009-08-28
Re: Dimension with Surrogate key of other dimension
That is the definition of a 'snowflake' schema. Best practice is to avoid them when possible.
Re: Dimension with Surrogate key of other dimension
My opinion goes favourably with snowflake. I think you should build your conceptual model using the snowflake model as much as you can, and then, once you truly understand your business model, expected usage and behaviour, you will denormalized for performance optimization. And even there, for a lot of cases, I would recommend that you create the physical snowflake tables and the denormalized tables. Today’s ETL tools allow you to automate that denormalization so that you don’t have any duplicate in your ETL process, therefore no risk of data integrity issue. Also, BI tools now support pretty well the snowflake, and they are less a problem with DW enabled RDBMS. In addition to that, a snowflake model will allow you to reuse some part of the snowflake dimension (higher hierarchy) along with your aggregates (ex : the geographic attributes of the customer could be a dimension by itself and usable for an aggregate or another fact table).
Similar topics
» Surrogate keys and Dimension-to-Dimension links
» Surrogate Keys in ODS and Dimension
» Eliminate Date Dimension Surrogate Key
» Resetting Dimension Surrogate Keys
» Surrogate keys in dimension and fact table
» Surrogate Keys in ODS and Dimension
» Eliminate Date Dimension Surrogate Key
» Resetting Dimension Surrogate Keys
» Surrogate keys in dimension and fact table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|