what is materialised view? why we use it in data warehousing?
- 5 Answers
- 9382 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
please please give me some banking calculations in framework manager.
What is a Pivot?
What are all the advantages of Cognos?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
i have one file i saved in csv how can i take these file into framework manager
Can you define a datastore in cognos?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
how to explain health care project and which reports we can create in health care doain?
What is a dimension?
What is the difference between ‘macro’ and ‘prompt?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
what is power prompt in cognos ep7series?what is the use of this?
What is the information present in the cognos configuration file?
Can you define report item?
