Mini Dimensions

tim_goodsell at 01h02
24
Sep
2010
Mini Dimensions

Hi

In out data warehouse design (superannuation) we need to cater for Client and Accounts and the relationship between them (a client can have one or more accounts). Some of the client attributes can change so we were thinking or having a client dimension and also a mini dimension for the changing attributes. Also some of the account attributes can change frequently so we were thinking of having an account dimension and an account mini dimension for the
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
What do you call your junk dimensions? Do you use "junk" in the dimension name? Junk implies garbage so I don't like using it. Most dimensions are easily named since they represent a single person, place, thing, concept, or event. Junk
Hello, Suppose I have following Fact and Dim table CustomerDim CustomerKey CustomerID CustomerNumber CustomerName CreditLimit - Slowly Changing, wants history IsAnnualMember - Slowly Changing, can be different from year to year or
My customer list is huge (about 70 millionish). We currently have a 60 million row dimension (CUSTOMER) that holds most of our existing customers, and this existing large DIM is currently performing fine for us. Now my clients want to type 2 two
Di masa yang maju ini, komputer makin lama menyusut ukurannya dan selain itu kreativitas desain juga membuat bentuk pc makin lama makin beragam dan bervariasi. Demikian pula pc mini dari eMachines yaitu Mini-e ER1402 memiliki desain modern dan futuristik
What is the best way to handle dimensions that change depending on user parameters? For example, lets say you want "Months Since Inception" to be a dimension, because you want to bucket by it (i.e. 0 to 50 Months, 51 to 100 Months, etc.) but
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"Mini Dimensions"

This topic has been viewed 2852 times.

Last message :
24/09/2010 at 01h02 by "tim_goodsell"