Customer Dimension Modeling - Level attribute

View previous topic View next topic Go down

Customer Dimension Modeling - Level attribute

Post  Manivannan on Mon Sep 09, 2013 3:19 pm

Hi,
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.

Thanks,
Mani

Manivannan

Posts : 1
Join date : 2013-09-09

View user profile

Back to top Go down

Re: Customer Dimension Modeling - Level attribute

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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