Role playing dimension is used when a dimension table is reused to join with a fact table more than once. A classic example of a role playing dimension can be a Time Dimension which joins with a Fact table. This Fact table contains OrderDate,ShipDate,ReceiveDate etc. To get these dates you will create just one table for TimeDim in […]

Continue reading