Question
A single Date dimension is joined as Order Date, Ship Date, and Delivery Date. What modeling technique is this?
Select an option. Your answer will be checked instantly.
Correct Answer: C. Role-playing dimension
Explanation:
One physical dimension can serve several logical roles in a business process.
Each foreign key expresses a different date context for the same fact row.
Leave a Reply