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

What is the difference between drill through, drill across?

1085


What are the advantages of cognos?

979


How can we Maintain the Cube Security by Category level and Dimension level ?

2359


Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

2120


Can you define report item?

1036


What are the services provided in cognos 8?

1031


What are the different types of reports present in cognos?

984


How create measures and dimensions?

1076


How to generate cubes in cognos?

972


What are initial page components of Cognos connection?

1013


What do you understand by the term 'dynamic cube'?

1016


faq's on cognos

4045


How can we create a dynamic column name in cognos?

954


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

964


What are all the components of Report Studio?

1096