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
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
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
HmongThoobNtiajTeb. com/
LEGO Island Discussion, modding, news and more!
Search
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"






