Fact table design based on sales appointments

View previous topic View next topic Go down

Fact table design based on sales appointments

Post  dmcgivney on Mon Jul 16, 2012 10:11 pm

I am looking for advice on fact table design.
I have 2 base tables. Sales Appointments and Sales Proposals.
An Appointment may have 1 or many or no Sales Proposals.
We wish to analyze this data by appts and proposal. So my most granular fact is the proposal if it exist.
Table examples are abreviated.
ApptTable:
ApptID, Date, Type, Customer data...
Proposal Table:
ApptID, Date, Type, SubType, Amt,OutCome

Is it "ok" to have a wide table with appt data, customer data and proposal data would be null?
If a single table the appt data would be repeated many times, using Distinct counts handles this issue.

Comments and advice are appreciated.

dmcgivney

Posts : 1
Join date : 2012-07-16

View user profile

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