In a joiner transformation, you should specify the source with fewer rows as the master source. Why? - Joiner transformation compares each row of the master source against the detail source. The fewer unique rows in the master, the fewer iterations of the join comparison occur, which speeds the join process. - 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: In a joiner transformation, you should specify the source with fewer rows as the master source. Why?

Answer: Joiner transformation compares each row of the master source against the detail source. The fewer unique rows in the master, the fewer iterations of the join comparison occur, which speeds the join process.

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

Question: In a joiner transformation, you should specify the source with fewer rows as the master source. Why?

Answer:

Joiner transformation compares each row of the master source against the detail source. The fewer unique rows in the master, the fewer iterations of the join comparison occur, which speeds the join process.
Source: CoolInterview.com

Joiner Transformation will cache Master table's data hence it is advised to define table with less #of rows as master. Source: CoolInterview.com

Answered by: vijaya | Date: 10/12/2008 |

Contact vijaya

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
	If you want to create indexes after the load process which transformation you choose?	View Answer
	Where is the cache stored in informatica?	View Answer
	How to get two targets T1 containing distinct values and T2 containing duplicate values from one source S1.	View Answer
	What will happen if you are using Update Strategy Transformation and your session is configured for "insert"? What are the types of External Loader available with Informatica? If you have rank index for top 10. However if you pass only 5 records, what will be the output of such a Rank Transformation?	View Answer
	What are the real time problems generally come up while doing/running mapping/any transformation?can any body explain with example.	View Answer
	Can batches be copied/stopped from server manager?	View Answer
	What is rank transformation?where can we use this transformation?	View Answer
	What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow monitor? . The system hangs when 'Online' server connect option. The Informatica is installed on a Personal laptop.	View Answer
	How can you delete duplicate rows with out using Dynamic Lookup? Tell me any other ways using lookup delete the duplicate rows?	View Answer
	In realtime which one is better star schema or snowflake star schema the surrogate will be linked to which columns in the dimension table.	View Answer
	What is the mapping for unit testing in Informatica, are there any other testings in Informatica, and how we will do them as a etl developer. how do the testing people will do testing are there any specific tools for testing	View Answer
	How do u check the source for the latest records that are to be loaded into the target. i.e i have loaded some records yesterday, today again the file has been populated with some more records today, so how do i find the records populated today.	View Answer
	While running multiple session in parallel which loads data in the same table, throughput of each session becomes very less and almost same for each session. How can we improve the performance (throughput) in such cases?	View Answer
	Can Informatica load heterogeneous targets from heterogeneous sources?	View Answer
	How do you load the time dimension.	View Answer
	What are the properties should be notified when we connect the flat file source definition to relational database target definition?	View Answer
	What is hash table informatica?	View Answer
	What is meant by EDW?	View Answer
	How to load the data from people soft hrm to people soft erm using informatica?	View Answer
	What are the measure objects	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