Answer Posted / abhishek
When the Integration Service processes a Joiner transformation, it reads rows from both sources concurrently and builds the index and data cache based on the master rows. The Integration Service then performs the join based on the detail source data and the cache data.
The number of rows the Integration Service stores in the cache depends on the partitioning scheme, the source data, and whether you configure the Joiner transformation for sorted input.
To improve performance for an unsorted Joiner transformation, use the source with fewer rows as the master source. To improve performance for a sorted Joiner transformation, use the source with fewer duplicate key values as the master.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we create multiple integration service on single repository?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the surrogate key?
can u any challenge your project?
what is SDLC way of code development?
How you can differentiate between connected lookup and unconnected lookup?
How do you load first and last records into target table?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the uses of etl tools?
What is sequence generator transformation in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Is it possible to create multiple domains on a single Informatica server?
Is there any way to read the ms excel datas directly into informatica?
Explain pmcmd command usage in informatica
What is a surrogate key?
