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
Which lifecycle we will use for reporting?
What is called a slice?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
which type of project we r going to snowflake schema
Can you explain model durability?
--------------Diff b/w ODS and OLAP?
----------------Diff b/w Dimensional modeling and Relational modeling?
New coloums are added in database, then how you know in report level
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What is the model filter?
What is the difference between group and associare?
What are the considerations regarding performance kept in mind while setting up cognos?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Can you define a datastore in cognos?
What are all the components of Report Studio?