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.
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
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.
What is exclusive and normal mode for repository services?
scenario where i can use only concurrent execution of workflow.
How we can use union transformation?
What is a repository? And how to add it in an informatica client?
How might one distinguish in the case of mapping is right or not without associating session?
What are the different transaction levels available in transaction control transformation?
How to configure mapping in informatica?
How union transformation is used?
differences between service based and product based?
What are the mapping parameters and mapping variables?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Why do we need informatica?
What does reusable transformation mean?
Global and Local shortcuts. Advantages.