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
- 13021 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 is the different lookup cache(s)?
what is unit testing?tell me proceedure
What is the difference between stop and abort in informatica
What is decode in informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
list out all the transformations which use cache?
Explain sessions and how many types of sessions are there?
Could you explain what is enterprise data warehouse?
Mention some types of transformation?
What are the different versions of informatica?
How many types of sessions are there in informatica.please explain them?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to create the source and target database connections in server manager?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
what are factless facts? And in which scenario will you use such kinds of fact tables.
