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
- 13947 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
Describe expression transformation?
What are some examples of informatica etl programs?
What is the advantage of informatica?
What is an aggregator transformation?
What do you understand by a term domain?
Can you use flat files in Mapplets.
How to differentiate between the active and passive transformations?
Explain incremental aggregation in informatica
What are Dimensional table?
Different circumstance which drives informatica server to expel records?
Global and Local shortcuts. Advantages.
How can repository reports be accessed without sql or other transformations?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is meant by a domain?
Mention few advantages of router transformation over filter transformation.
