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 materialized view?

Answer Posted / shruthi

Materialized views are schema objects that can be used to
summarize, precompute, replicate, and distribute data. E.g.
to construct a data warehouse.

A materialized view provides indirect access to table data
by storing the results of a query in a separate schema
object. Unlike an ordinary view, which does not take up any
storage space or contain any data.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2012


Why update strategy and union transformations are active? Explain with examples.

1188


What is an aggregator transformation?

1038


What is the maplet?

1060


How do you update the records with or without using update strategy?

1067


What all are steps in up gradation of Informatica server?

1001


Explain sessions. Explain how batches are used to combine executions?

960


How to create the source and target database connections in server manager?

1046


What are some examples of informatica etl programs?

898


Can we create a node as a gateway node and the same node can be assigned to a grid?

1038


What happens when a session fails and you click on recover?

1081


What is the difference between stop and abort in informatica

1053


Plz can any one say me how to get the informatica certification materials and dumps

2013


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

983


How to create Target definition for flat files?

1168