Interested to Buy Any Domain ? << Click Here >> for more details...
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
Which is the t/r that builts only single cache memory?
wf dont have integration severances how you can run?
What are the databases that informatica can connect to windows?
Explain the scenario which compels informatica server to reject files?
How will the document be delivered to me?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are the various types of transformation?
How to go to the older version for a mapping?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
tell me the rules and responsblites in our project(my project is development)
What is status code in informatica?
What happens when a session fails and you click on recover?
How to elaborate tracing level?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How many input parameters can exist in an unconnected lookup?
