Continuing with our tutorial on Type of Dimension in data warehouse , we talked about to Conformed Dimension and Junk Dimension and their importance in Data warehouse technology. In below article we will go through the Role Playing Dimension in data warehouse with some example along with their .Hope you will enjoy this small data warehouse tutorial.
Role Playing Dimension Kimball definition
A single physical dimension can be referenced multiple times in a fact table, with each reference linking to a logically distinct role for the dimension.It is essential that each foreign key refers to a separate view of the date dimension so that the references are independent. These separate dimension views (with unique attribute column names) are called roles.
Check here for Degenerate Dimension in Data warehouse
What is Role Playing Dimension ?
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
Check here for Conformed Dimension in Data warehouse
Importance of Role Playing Dimension
- All the logic for a subject area is encapsulated in the one area (dimension). This means that all cube dimensions (for examle date) that use the role playing dimension are consistent with the same definitions etc.
- Additionally, less development time & less chance of errors
- Less storage would be needed for roles of a single dimension than would be necessary for separate dimensions.
Check here for Junk Dimension in Data warehouse
So in above data warehhouse tutorial ,we have gone through some basic concept of Role Playing dimension , along with importance and its advantages.