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 are initial page components of Cognos connection?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
Explain difference between powerplay transformer and power play reports?
What is the difference between a cascading report and drill through the report?
How security is concerned with Reportnet? Explain its implementing steps.
difference between impromptu and cognos8
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What are the roles defined by cognos platform?
5. Which type of report you build more, list, crosstab or chart and why?
How do we convert from Numeric to be Words?
Can you define fan trap?
Define catalog in cognos and write its various types?