Hi All
I have a query regarding creating master table in database vs creating a model QS in FWM. Below are the details.
Example: We have tables A,B,C. B,C have one to many relationship with A. We need a master table combining columns from all 3 tables.
Our DBA wants to know what difference does it make to create this master table in database Vs creating a model query subject with required columns in FWM in business layer by joining the tables. What is the difference between these two approaches.
Please let me know which is the best approach and why.
Thanks in advance.
As per my knowledge gathered from going through couple of links, having a Mastertable or View created in DB will enhance the performance of the query execution, because joins among tables will be taken care by DB resources and do not put load on Cognos server. We can import the Mastertable/View into FWM and avoid giving joins in FWM.
Is this true? Can I get any technical details to substantiate my assumption or any other ideas please.
TIA
Bump !!!