Fact table design based on sales appointments
Page 1 of 1
Fact table design based on sales appointments
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.
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
Similar topics
» Fact table design: Sales Transaction with multiple Discount rows
» Sales Rep <--> Customer relationship with Sales Fact Table
» FACT Design Question - How to design FACT Table when computation is required on the degenerate dimension?
» Design a snapshot Fact table in data mart from compliance-enable fact table in enterprise data warehouse
» Sales Rep <--> Customer relationship with Sales Fact Table
» FACT Design Question - How to design FACT Table when computation is required on the degenerate dimension?
» Design a snapshot Fact table in data mart from compliance-enable fact table in enterprise data warehouse
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum