Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialised view? why we use it in data warehousing?
- 5 Answers
- 10216 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
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 is difference between data mart and data warehouse?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
----------------Diff b/w Dimensional modeling and Relational modeling?
What are initial page components of Cognos connection?
Mention the difference between ‘macros’ and ‘prompt’?
What junk dimension contains?
What are the types of hierarchies?
Can you define a catalog and types of catalogs in cognos?
How can I test reports in cagonos?
How create measures and demensions?
What is the difference between set functions and filter function in dimensional data?
5. Which type of report you build more, list, crosstab or chart and why?
how u will determine the performence tune will occur either in report or system
Can you define metrics designer?
