Specify acceptable Snowflaking scenarios

bi_at_nj at 05h49
31
Oct
2009
Specify acceptable Snowflaking scenarios

Can someone please specify acceptable snowflaking scenarios.

- Thanks in advance
bi_at_nj

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Snowflaking Dimensions
I've got two related questions. Question 1: Building an insurance data warehouse, you have a DimPolicy table (for the insurance policy) and a FactPolicyTransaction table (for the transactions on that policy). There is an insurance agent that is
Dimensions Directly Tied to Facts vs. Snowflaking
Hi all, Thanks in advance for your input on this. We are in the midst of a building out a portion of our data warehouse. The example here has to do with insurance data. Hopefully the discussion can be abstracted to a more generic modeling level. We
ETL Optimization Scenario
Hi All, Currently size of our fact table is in millions which will continue to expand and pretty soon our ETL processes will fail, so need to optimize them now before it gets out of hand. So we need to create a scenario which will allow was to test ou
Snowflake scenarios
Had seen a few places where dimensions were snowflaked. But how do we figure out that these snowflaked dimensions are justified? Specify scenarios where snowflaking is acceptable. Thanks in advance, bi_at_nj
Periodic snapshots - what is better?
Apologize in advance for a lengthy but general query – I hope there is an expert who has done this many times that can help me. We need to build a periodic snapshot table in our data warehouse. This is an example of a bank that needs to store account
Forums from same category
Informations

8 Replies For the topic :
"Specify acceptable Snowflaking scenarios"

This topic has been viewed 1497 times.

Last message :
31/10/2009 at 05h49 by "bi_at_nj"