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
- 13982 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
Define enterprise data warehousing?
What is the difference between informatica 7.0 and 8.0?
What is the maplet?
How to convert multiple rows to single row (multiple columns) in informatica
What is the session task and command task?
What does refresh system mean, and what are its distinctive choice?
What are the main issues while working with flat files as source and as targets ?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are ETL Tools?
what is diff b/t sorter t/r and agg have the option sorter property...
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What do you mean by channel change?
What is domain and gateway node?
What are the reusable transformations?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
