As per Wikipedia, A dimension is a structure that categorizes facts and measures in order to enable users to answer business questions.
Commonly used dimensions are people, products, place and time.
If we consider the Data-warehouse scenario of Online Ticket Booking, The first dimension that comes to mind is for List of cinemas.
So, if at any point of time business needs to find out how many tickets were sold for each cinema, they could simply join Dim_Cinemas with tickets table as detailed in below image.
This suggests that 2 tickets were sold in cinema C1 and 1 ticket was sold for cinems C2
There are many types of dimension in a data warehouse listed here.
Commonly used dimensions are people, products, place and time.
If we consider the Data-warehouse scenario of Online Ticket Booking, The first dimension that comes to mind is for List of cinemas.
So, if at any point of time business needs to find out how many tickets were sold for each cinema, they could simply join Dim_Cinemas with tickets table as detailed in below image.
This suggests that 2 tickets were sold in cinema C1 and 1 ticket was sold for cinems C2
There are many types of dimension in a data warehouse listed here.
No comments:
Post a Comment