June 19, 2008 at 7:26 am
Hello, I am quite new to BI and I am going through a project already built by another guy.
I have noticed that he used view as fact tables.
My question is: since ETL process and cube are processed once a day and all dimensions are static the result of the view is static as well...would it worth to replace those views with tables in order to get better performance?
Thanks
Nicola
June 19, 2008 at 8:30 am
Once the cube is processed (assuming MOLAP storage) the data mart is not queries again until you process the cube the next time. So, you could have a horribly slow view as your fact "table" and it will have absolutely no impact on the performance you will get in your cube querying.
A slow view will slow down cube processing, but copying the data from the view into a table during your ETL process vs. directly accessing it during cube processing will probably just move your performance issue from one part of your ETL process to another.
A view for a fact table leads me to believe that you do a full process of the cube regularly rather than incremental processing - is this true?
June 19, 2008 at 12:29 pm
Yes...exactly...so far the system is built to run full etl and full processing of the cube once a day....
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply