Need help in Fact table designing
3 posters
Page 1 of 1
Need help in Fact table designing
Hi,
I am new to DWH, can you please help me to design Fact table.
Basically I am working on a Airline Industry project where a customer book a flight and multiples charges apply on a booking and customer can have a single payment or multiple payments.
Here is my relational database structure :
============
Booking Table
============
BookingID
BookingDate
--------------------
============
Charges Table
============
BookingID
ChargeID
ChargeDate
ChargeType
ChargeAmout
--------------------
============
Payment Table
============
BookingID
PaymentID
PaymentMethod
PaymentDate
PaymentAmount
--------------------
Now I am confuse to take fact table design, how many fact table should I design for this scenario ?
There are three cases :
1. A BookingID can have single charge and single payment .
2. A BookingID can have single charge and multiple payments
2. A BookingID can have multiple charges and multiple payments
Please help me.
Thanks,
Randhir
I am new to DWH, can you please help me to design Fact table.
Basically I am working on a Airline Industry project where a customer book a flight and multiples charges apply on a booking and customer can have a single payment or multiple payments.
Here is my relational database structure :
============
Booking Table
============
BookingID
BookingDate
--------------------
============
Charges Table
============
BookingID
ChargeID
ChargeDate
ChargeType
ChargeAmout
--------------------
============
Payment Table
============
BookingID
PaymentID
PaymentMethod
PaymentDate
PaymentAmount
--------------------
Now I am confuse to take fact table design, how many fact table should I design for this scenario ?
There are three cases :
1. A BookingID can have single charge and single payment .
2. A BookingID can have single charge and multiple payments
2. A BookingID can have multiple charges and multiple payments
Please help me.
Thanks,
Randhir
Re: Need help in Fact table designing
What types of questions are you trying to answer?
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Need help in Fact table designing
Can you please suggest me the structure of Fact table. And I want to know how many fact table required for this case and what is best practice.
Re: Need help in Fact table designing
Two. One for charges, the other for payments. Booking ID would be a degenerate dimension, booking date a dimension as well. I would assume there would be other dimensions as well.
Re: Need help in Fact table designing
I know you want to build fact tables. The question is a business question. What are you KPI's? What are you counting? The answers to those questions will tell you how many fact tables to build. Or you could just build whatever the data supports independent of business requirements.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Problem while Designing Fact table
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» How to create fact table with measures derived from comparing two fact table rows
» Designing a Fact for Sales DW
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» How to create fact table with measures derived from comparing two fact table rows
» Designing a Fact for Sales DW
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum