Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialised view? why we use it in data warehousing?
- 5 Answers
- 10660 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / gopal
MT views is a table which occupies space when ever we update it doesn't update in parent table we need to write a command to refersh the data in to parent table
Mainly used for Pre-aggregated Calculations....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Standard and Metrics folder?
how u will determine the performence tune will occur either in report or system
What is metric store database?
Can you define materialized view?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
What is difference between page break and section report?
What is difference between data mart and data warehouse?
What is set to be Cognos configuration?
How to a create header dynamically in a crosstab report in cognos 8.1?
--------------Diff b/w ODS and OLAP?
----------------------What are the User Securities?
Can you define confirmed dimension?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
where you can save the report net documentation in our local system?
What are the other methods working as deployment functionality?
