Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / manoj

Materialized view contains special cache to store the data
and structure of the table.

it improves the perrformance becuase when we write the
query every time data is not feched from the base table
i.e. we will use in Datawarehouse.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which lifecycle we will use for reporting?

916


What is called a slice?

975


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1926


which type of project we r going to snowflake schema

1931


Can you explain model durability?

1001


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

3155


----------------Diff b/w Dimensional modeling and Relational modeling?

14878


New coloums are added in database, then how you know in report level

1516


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2325


What is the model filter?

958


What is the difference between group and associare?

985


What are the considerations regarding performance kept in mind while setting up cognos?

919


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

971


Can you define a datastore in cognos?

977


What are all the components of Report Studio?

1042