Hi, If I have a dimension, such as the employee dimension, that needs to be used for more than one key in the fact table, would I create a view or a materialized view for the second dimension? Or is there a different approach?
- Posts : 39
Join date : 2009-02-11
Neither, really. You just have multiple FKs to the same table based on the role. When you query you assign an alias to each use of the table. Within a typical BI tool, you define those aliases for each use of the table.
Permissions in this forum:You cannot reply to topics in this forum