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

What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

724


What is model filter?

643


what are the filters in framework manager and report studio?

600


how to perform single sign in cognos by using url?

578


what are the limitations of cognos reportnet? What are the enhancements in reportnet ?

630






How to apply securities for reports in cognos connection?

2135


Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

1767


What is difference between page break and section report?

700


how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

1708


Define cognos report net?

576


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

1346


hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1469


What junk dimension contains?

559


Why is auto-regression used in forecasting used on cognos platform?

551


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

1701