Customer Dimension with Unlimited Metadata

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

De-normalizing Customer Information to create a Customer Dimension

I have a question regarding de-normalizing customer data to create a single customer dimension! Let's say our OLTP customer information is made up of 2 tables. 1) Customer Table (customer name, customer type, etc...) 2) Address Table (address1,

Addresses in Customer Dimension

As part of an Orders dimensional model, I am attempting to design the Customer Dimension table. The customers have multiple sold-to addresses and multiple ship-to addresses. While the OLTP allows any Order to have any combination of sold-to and ship-to

desining customer Dimesnion

Hi All, I design customer dimensions, but in our concept we have two types of customer the customer as the owner and the customer as one member in customer group which we call it contract,and some times the contract is the owner One-To-one . From this

Customer Age

Hi, Does anyone know the best way to model customer age? I guess there are 3 options: 1)Just their birth date, 2)Their current age as an attribute, 3)their age as an attribute but make it a type 2 scd so that you get all their age history. This is

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

How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)

Hello, Within Ralph his new book he describes recommanded situations for snowflaking a dimension. His example is a large customer (visitor) dimension. (page 337, 338 and figure 10-6). I find the artical good, but there is missing one part of this

Unlimited Width - Unlimited Depth - 3x4 Forced Matrix!

Outstanding product! Outstanding Opportunity! Outstanding Tools! There's NO competition for this program! TriUnity has put together the most Unique, Simple, and yet, Powerful Compensation Plan ever developed. The goal in developing our plan wa

Walkins For Customer Support Executive In HCL Technologies Ltd

Experience:0 – 1 YearsHCL-Technologies Job Title:Customer Support Executive Location:Chennai Education:Graduate – Any Specialization Name Of company:HCL Technologies Ltd Job Description: Position:Customer Support Executive (Non -Voice BP

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Date Dimension

Hi All, I understood Kimball way of implementation Date Dimension table. In a way, the lowest granularity date represent each record, with the following month, quarter and year attribute. However, what happen if the lowest grain of certain fact are at

MDX(or something else) for getting history based on last dimension characteristic for SCD.

Hi everyone, I am implementing a cube and I run into a problem with slowly changing dimensions(SCD type 2). I guess it might be resolved somehow with MDX or somehow else, maybe you guys can help me to resolve it. The problem: I have SCD, say Policy wit

What Does SimBrothel Need?

There’s a great group of people who are attempting to forge this game into the best it could be and while I declined to be an active part of that I still want to support them in whatever small way I can. To that end, I thought it would be beneficial to