Monster Dimensions
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

Customer Dimension
I am trying to model a Customer Dimension with Educational and Employment details and I want some advice on how to model this scenario A Customer can have several levels of Education like schooling, college, university, training (one to many realtionship

Hierarchy within single dimension or two dimensions
I am unsure of the best way to model a specific business scenario and was looking for some input. I will explain it in terms of a common example, the Product dimension. Let's say that every "product" is assigned to a specific

Same attribute in multiple dimensions or Create new dimension?
Hi all - I'm struggling with this concept. I have 2 dimensions: Customer and Products. Both share a common single attribute that I'll just call "Owner" for now. If a customer purchased a product, the owner would be the same for both. I

Multivalued Dimension or Multiple facts w/conformed dimensions
I am trying to model for insurance industry, with data as follows: We have data at different levels: Policy level with related facts. ((Premium , face amount, mode etc) Policy Fund level (combination with related fact values.) Policy Rider level

How to model Product Bundles
The situation: Wholesale sales business process SKU1 and SKU2 can each be sold separately. SKU3 can also be sold separately but is a kit of SKU1 and SKU2. We need to calculate royalties for each unit we sell of SKU1 and SKU2. SKU1 has two royalty

Populating Product dimension
Hi, I have a Product dimension table which I need to populate. There are 2 columns in this dimension 'Product Code' and 'Product Description'. The Product Code comes from a concatenation of 2 columns from my staging table (which forms the business

Textual values in dimension tables
With much interest I am reading "The Data Warehouse Toolkit", and I stumble upon a design thing that I have done differently in my Data Warehouse design (this is described in the book on page 42). It describes about the dimension table that it

Dipped Product Plc
http://www.cse.lk/cmt/upload_report_file/670_1296617668150.pdf

Dynamic dimensions
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

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

Large Dimension table compared to fact table?
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

All About Elken Health Product
Assalamualaikum.... Saya nak tanya ada sesiapa yang pernah menggunakan product kesihatan Elken? Kalau ada, sila bagi testimoni anda....ramai yang cakap product elken ni bagus dan effective. Saya pernah cuba elken spirulina sbb saya ni jenis yang

Sparse dimensions, how to handle?
I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Dates in many dimensions
Hello, I am new to DW. Currently, I am working on a Human Resource database. There are many tables in the source systems which stores dates e.g. dates about contract start, finish, Vacations of an employee, temporary service suspension and many more.