what is materialised view? why we use it in data warehousing?
Answer Posted / gopal
MT views is a table which occupies space when ever we update it doesn't update in parent table we need to write a command to refersh the data in to parent table
Mainly used for Pre-aggregated Calculations....
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
what are the names of the reports that you prepared?
How create measures and dimensions?
how to merge 2 crosstabs thans
what are the errors faced while bursting the reports and how to solve those errors?
Can you define drill down and drill up?
Can we test the report other than manual testing?
Explain what is the difference between native sql and cognos sql?
whats the difference between previous version of cognos and cognos 8 BI?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
What is Metrics designer?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
i have one file i saved in csv how can i take these file into framework manager
What are all types of Batches?