Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialised view? why we use it in data warehousing?
- 5 Answers
- 10474 Views
- HCL, I also Faced
- E-Mail Answers
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
What is Bitmap Index?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What are query items?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What is the complex report you faced in real time?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What is difference between primary key and unique key constraints?
What is the difference between regular dimension and derminant?
What is main advantage datawarehousing over oracle?
What do you mean by drill through report?
what is requery in cognos?
What is cognos powerhouse?
What are the considerations regarding performance kept in mind while setting up cognos?
Define query items?
