what is materialised view? why we use it in data warehousing?
Answer Posted / manoj
Materialized view contains special cache to store the data
and structure of the table.
it improves the perrformance becuase when we write the
query every time data is not feched from the base table
i.e. we will use in Datawarehouse.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
what is the procedure for scheduling conditional rendering?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What are the other methods working as deployment functionality?
What are all the components of Report Studio?
Can you define a datastore in cognos?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
What are the considerations regarding performance kept in mind while setting up cognos?
What are the two types of framework manager?
4. How many dimensions did you use in your reports?
How to join multiple db in catalog?
Cleared COG-112 with 100% score today. What next certification should i go for?
How security is concerned with Reportnet? Explain its implementing steps.
How can we Maintain the Cube Security by Category level and Dimension level ?