In last few tutorial , we started talking about various Type of dimension in Data ware house and what role they play in data warehouse.Last time we talked about Conformed dimension and Junk Dimension . Data warehouse mainly consists of Dimension and Fact tables. In below article we will go through the Role Playing Dimension in dataware house with some example , why they are important.Hope you will enjoy this small data warehouse tutorial.
Role PlayingDimension in Data warehouse
A dimension is Role playing dimension , with multiple valid relationships between itself and another table . This is most commonly seen in dimensions such as Time and Customer.
For example :In below Order Fact Table , it has multiple relationships to the Date dimension on the keys Order_date ,shipping_date. Now to handle this situation instead of creating two separate dimension table we can create two views of original date dimensions table one is Order_date_dim and another is ship_date_dim
I found a good article on Role Playing dimension in data ware house here
I also found some good article on other various type of dimension as well.
