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

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

2076


Explain is there any comparison available for cognos reportnet vs crystal reports?

942


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

2357


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2748


7. What is performance tuning?

1982


What is catalog and types of catalogs in cagonos and which is better?

988


Can you explain model durability?

1047


how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

1038


Diff b/w Crossproduct and Outerjoin?

2269


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2413


5. Which type of report you build more, list, crosstab or chart and why?

2010


Can you define metrics designer?

1045


Define query items?

993


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1682


Can you define bitmap index?

1045