Role Playing dimension is a dimension, it can play different roles in a fact table depending on the context.
For example: Date dimension
Date dimension can be used for ordered date, shipping date, shipment date, and invoice date, etc., in an order line fact.
In the data warehouse, you will have a single dimension table for the dates. You will have multiple warehouse foreign key from the fact table to teh same dimension.
No comments:
Post a Comment