what is materialised view? why we use it in data warehousing?
Answer Posted / ram
Materialised view will stores the results of sql in the tables form in the database. materialised view contains data physically.view doesn't contain data physically.materialised view will be updated with batch upted know as refreshes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between static and dynamic conditions?
What is main difference mapplets and mapping?
Why cognos decision stream is used?
What are the types of hierarchies?
How can create users and permissions in cognos?
how you provide security to reports? How you provide security to packages ?
How do we drill through from a powerplay cube to reportnet?\
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What is called Cognos powerplay?
Can you define dimension?
Can you define metrics designer?
How can I test reports in cagonos?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
What is model?
How is cognos model organization works?