Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Experts,
Performance Wise Which transformation is better in LOOKUP
AND JOINER TRansformations? Why? Can anybody please explain
it ?
Please help me out from this Question.
Thanks In Advance.
- 2 Answers
- 14082 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / sukanta
Look up will better perform because the cache is initially
created when the first record will reach at Look up
tarnsformation and the further records are work upon the
cached records.Look up will perfrom left outer Join
only.Other Joins can't be posible.You can check the records
are either exists in the lookup table or not.
Jioner will be slower than look up but sorted port
Join,well choosing of Master and detail configuration will
give better performance for Joiner.
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What are the limitations of joiner transformation?
What is the function of aggregator transformation?
What are the different types of repositories created using informatica?
tell me about your project functionality
Enlist few areas or real-time situations where informatica is required.
Explain the types of transformations?
Explain what are the different types of transformation available in informatica.
What do you mean by channel change?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain the code page compatibility?
What are the guidelines to be followed while using union transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a sequence generator transformation?
What are the mapping parameters and mapping variables?
How do you load alternate records into different tables through mapping flow?
