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

sql server - can I use a view as fact table

2 posters

Go down

sql server - can I use a view as fact table Empty sql server - can I use a view as fact table

Post  hurrican3dev Tue Jan 15, 2013 2:16 pm



I know that in terms of processing data into the cube it is no big deal, but does this make sense from the relational warehousing side?


thanks

hurrican3dev

Posts : 17
Join date : 2012-08-26

Back to top Go down

sql server - can I use a view as fact table Empty Re: sql server - can I use a view as fact table

Post  ngalemmo Tue Jan 15, 2013 6:08 pm

It all depends on the view. If it is simply a different representation of an existing fact (such as calculating derived measures) sure, there is usually little or no impact on performance. If the view performs significant transformation, such a joins, use of windowing functions, etc, there may be significant performance impacts.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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