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

data mart without facts

2 posters

Go down

data mart without facts Empty data mart without facts

Post  dbadwh Fri Sep 30, 2011 3:29 pm

Hi,
Currently I have to design a data mart for broker and customer relationship. The requirement is to see the details of the customer like customer name, address, location, age, start date of the activity and end date, active inactive customer, etc. There is no measurable or any additive facts at all. Can any one tell me how to go ahead on this?

dbadwh

Posts : 31
Join date : 2011-09-30

Back to top Go down

data mart without facts Empty Re: data mart without facts

Post  ngalemmo Fri Sep 30, 2011 3:41 pm

dbadwh wrote:Hi,
Currently I have to design a data mart for broker and customer relationship. The requirement is to see the details of the customer like customer name, address, location, age, start date of the activity and end date, active inactive customer, etc. There is no measurable or any additive facts at all. Can any one tell me how to go ahead on this?

The relationship is the fact. Use a fact table to record the relationship. If there are no measures, so be it.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

data mart without facts Empty Re: data mart without facts

Post  dbadwh Sat Oct 01, 2011 2:36 am

ngalemmo wrote:
dbadwh wrote:Hi,
Currently I have to design a data mart for broker and customer relationship. The requirement is to see the details of the customer like customer name, address, location, age, start date of the activity and end date, active inactive customer, etc. There is no measurable or any additive facts at all. Can any one tell me how to go ahead on this?

The relationship is the fact. Use a fact table to record the relationship. If there are no measures, so be it.

Thats what I was also thinking. Thank you.

dbadwh

Posts : 31
Join date : 2011-09-30

Back to top Go down

data mart without facts Empty Re: data mart without facts

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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