Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Customer Dimension Modeling - Level attribute

2 posters

Go down

Customer Dimension Modeling - Level attribute  Empty Customer Dimension Modeling - Level attribute

Post  Manivannan Mon Sep 09, 2013 3:19 pm

I am in the process of designing loyalty customers transactions data mart. Now, I need to create Customer Dimension, here each customer will have their own unique ID, and based on their transaction points they will be moved to different levels like from Level 1 to Level 2 and so on. So the levels will be changed periodically. In this case, what should I do? should I create customer dimension as slowly changing dimension (then customer key will change) or Should I keep separate Customer-Level  (relationship table between customer and level)  with slowly changing dimension? Please advise me.



Posts : 1
Join date : 2013-09-09

Back to top Go down

Customer Dimension Modeling - Level attribute  Empty Re: Customer Dimension Modeling - Level attribute

Post  ngalemmo Mon Sep 09, 2013 6:18 pm

Ok, levels change. So do other things about the customer. Creating a type 2 dimension only matters if you want to keep history.

Do you? And if so, what do you want history of? All customer attribute changes or just the customer level? And what are they going to do with it?

There are a lot of ways to keep history:

1. Type 2 dimension. Gives you full history. And yes, the PK changes. So what? Everybody seems to think that is a problem. It isn't. Its a very useful feature.

2. Type 3 dimension. Keep some fixed # of generations of history for a few attributes. Simple, can be effective.

3. Maintain a history of states as a fact table. Keep current in a type 1 customer dimension for ease of use. Customer/Date/Level. Useful for tracking customer movement, but not a whole lot else.

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum