Large Mini dimension alternate ?
kaps at 00h02
29
Dec
2011
Large Mini dimension alternate ?
We are planning to create a Mini dimension for our customers with following fields as these fields would make the Cust Dim(Type-2) huge.
Cust State, Cust 3 digit zip(929 unique values), Age(120 unique values), Rating Age(15 unique values), Gender(3 unique values) and this is exploding as 929*120*15*3 would come around 5 millions which is very large for Mini dimension. Should we outrigg the 3 digit zip from Cust dim or cust mini dim ? What other
We are planning to create a Mini dimension for our customers with following fields as these fields would make the Cust Dim(Type-2) huge.
Cust State, Cust 3 digit zip(929 unique values), Age(120 unique values), Rating Age(15 unique values), Gender(3 unique values) and this is exploding as 929*120*15*3 would come around 5 millions which is very large for Mini dimension. Should we outrigg the 3 digit zip from Cust dim or cust mini dim ? What other
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1842
- Numbers of messages : 8656
- Numbers of users : 3787
- Numbers of points : 1497
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
I may be misguided in my attempt to make a dimensional model here, but I will explain the scenario. We provide a value add service in the supply chain business...in this case by depicting a scorecard of the accuracy of vendors' product sizing
I am designing a new dmensional model for an insurance company and users want to analyse the documents (stored in sharepoint) that have been attached to various entities (policies, claims etc.)
I have designed a Document dimension to hold some of 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
Hi all,
I have a Client Dimension and a Fact table which tracks Sessions with Clients, these have the following
Forums from same category
HmongThoobNtiajTeb. com/
LEGO Island Discussion, modding, news and more!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Search
See also
Informations
5 Replies For the topic :
"Large Mini dimension alternate ?"
This topic has been viewed 378 times.
Last message :
29/12/2011 at 00h02 by "kaps"
