what is materialised view? why we use it in data warehousing?

Answer Posted / suman palisetty

Materialized Views are objects which have information that has been aggregated and summarized from source tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write some methods to apply securities in framework manager model?

654


What is model filter?

628


---------------Describe OLAP Reporting and RDBMS Reporting?

1667


What is the difference b/w macros and prompt?

596


What DB View and Bus View?

1542






How to create a cube in Transformer? What is the process? Please mention process thank u

1333


What is the report studio?

598


What is zero-foot print?

595


Please explain the different stages in creating a report in cognos report net?

564


How to join multiple db in catalog?

570


Give me any example of semi and non additive measures?

555


What is metric store database?

565


What are the batches and it’s details?

567


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

604


-----------Diff b/w OLAP and RDBMS?

1620