Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialised view? why we use it in data warehousing?
- 5 Answers
- 10399 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / c.venkataramana gupta
->Meterialized view is DBA object
-> to create meterializd view need dba perimission(previlege)
->it holds the static data (changes on table will not reflected on view)
-> at time of creating the data is stored in meterialized view, when ever another new record is not restricted.
-> no dml operations allowed
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of studio present in Cognos?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
How security is concerned with Reportnet? Explain its implementing steps.
Can you define drill across?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
how to merge 2 crosstabs thans
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What is the importance of having monitor service in cognos?
Explain what is the difference between native sql and cognos sql?
------------------What is Inline Query?
What junk dimension contains?
What do you mean by drill across?
How to generate cubes in cognos?
What are all types of Batches?
