what is materialised view? why we use it in data warehousing?
- 5 Answers
- 8622 Views
- HCL, I also Faced
- E-Mail Answers
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
How to join multiple db in catalog?
How we check the errors before running the report?
How create measures and demensions?
i was asked what are the caluclations done by you in your report? plz give reply
1. Explain your project.
Can you define bitmap index?
------------- How to identify the Revenue Column in Report?
What is the size of the cube?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What are shortcuts? Where it can be used? What are the advantages?
what is catalog and types of catalogs in cagnos and which is better?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What is model filter?
how you create security to reports?
