Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

View or materialized view?

2 posters

Go down

View or materialized view? Empty View or materialized view?

Post  dellsters Thu Apr 08, 2010 6:10 pm

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

Back to top Go down

View or materialized view? Empty Re: View or materialized view?

Post  ngalemmo Thu Apr 08, 2010 6:40 pm

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.

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum