what is materialised view? why we use it in data warehousing?
Answer Posted / ram
Materialised view will stores the results of sql in the tables form in the database. materialised view contains data physically.view doesn't contain data physically.materialised view will be updated with batch upted know as refreshes.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is defined as data mining?
How is possible this scenario using in type-in prompt.?
How to create a cube in Transformer? What is the process? Please mention process thank u
What do you understand by the cognos?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What are cognos connection initial page components?
Can you define folder?
Mention the difference between ‘macros’ and ‘prompt’?
What is Metrics designer?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
Define catalog in cognos and write its various types?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
How do you Parametermap variables in Quiries?
Give the advantages of cognos?
Define the slice and dice?