what are the difference between view and materialized view? - 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 - Informatica Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

INFORMATICA

DETAILS

Question: what are the difference between view and materialized view?

Answer: 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

Category	Informatica Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 6613 users
Added on	7/26/2011
Views	70236
Rate it!

Question: what are the difference between view and materialized view?

Answer:

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

Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What is the difference between summary filter and detail filter	View Answer
	Compare Data Warehousing Top-Down approach with Bottom-up approach	View Answer
	Discuss which is better among incremental load, Normal Load and Bulk load	View Answer
	What is the difference between connected and unconnected stored procedures.	View Answer
	Differences between Informatica 6.2 and Informatica 7.0 Yours sincerely	View Answer
	What are the Differences between Informatica Power Center versions 6.2 and 7.1, also between Versions 6.2 and 5.1?	View Answer
	Whats the diff between Informatica powercenter server, repositoryserver and repository?	View Answer
	How to create the staging area in your database	View Answer
	What does the expression n filter transformations do in Informatica Slowly growing target wizard?	View Answer
	In a filter expression we want to compare one date field with a db2 system field CURRENT DATE. Our Syntax: datefield = CURRENT DATE (we didn't define it by ports, its a system field ), but this is not valid (PMParser: Missing Operator).. Can someone help us. Thanks	View Answer
	Briefly explian the Versioning Concept in Power Center 7.1.	View Answer
	How to join two tables without using the Joiner Transformation.	View Answer
	Identifying bottlenecks in various components of Informatica and resolving them.	View Answer
	Identifying bottlenecks in various components of Informatica and resolving them.	View Answer
	Can Informatica be used as a Cleansing Tool? If Yes, give example of transformations that can implement a data cleansing routine.	View Answer
	How do you decide whether you need ti do aggregations at database level or at Informatica level?	View Answer
	How do we estimate the depth of the session scheduling queue? Where do we set the number of maximum concurrent sessions that Informatica can run at a given time?	View Answer
	How do we estimate the number of partitons that a mapping really requires? Is it dependent on the machine configuration?	View Answer
	Suppose session is configured with commit interval of 10,000 rows and source has 50,000 rows. Explain the commit points for Source based commit and Target based commit. Assume appropriate value wherever required.	View Answer
	We are using Update Strategy Transformation in mapping how can we know whether insert or update or reject or delete option has been selected during running of sessions in Informatica.	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Informatica Interview Questions & Answers - Exam Mode / Learning Mode