data mart without facts

View previous topic View next topic Go down

data mart without facts

Post  dbadwh on 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

View user profile

Back to top Go down

Re: data mart without facts

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

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

View user profile http://aginity.com

Back to top Go down

Re: data mart without facts

Post  dbadwh on 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

View user profile

Back to top Go down

Re: data mart without facts

Post  Sponsored content


Sponsored content


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