what is materialised view? why we use it in data warehousing?
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
how to test reports in cognos?
Can you define pivot?
can you tell me what are the dimension tables are used in project
Can you define metrics designer?
-----------------What is Determination Model?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
Can you define framework manager?
Can you explain a cognos controller?
What is Metrics designer?
What do you mean by query studio?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
-----------With out using DrillThrough how to do Reports?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
Can you define materialized view?