View or materialized view?

View previous topic View next topic Go down

View or materialized view?

Post  dellsters on 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?

dellsters

Posts : 39
Join date : 2009-02-11

View user profile

Back to top Go down

Re: View or materialized view?

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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