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

Questions by rrvathana

Showing Answers 1 - 2 of 2 Answers

vishali

  • Apr 14th, 2006
 

in joinner transformation informatica server reads all the records from master source builds index and data caches based on master table rows.after building the caches the joiner transformation reads records from the detail source and perform joins

sunil_reddy

  • Apr 14th, 2006
 

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.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions