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 are the limitations of cognos reportnet? What are the enhancements in reportnet ?

833


what are the dimensions that you have in your current project?list them?

1831


What is the function of model design accelerator?

705


what is online view?

1715


How can we create a dynamic column name in cognos?

719


What are all the advantages of Cognos?

806


what is model and say about process how to create model and how to test model?

784


Can you define cognos decision stream?

759


9. What was the most complex type of report you dealt with?

1898


if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1709


Can you define report item?

790


Define report item?

862


Explain what is the difference between microstrategy and cognos reporting tool?

752


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

2043


Can you define cognos powerplay?

838