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
- 13854 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
Partition, what happens if the specified key range is shorter and longer
What is the way to execute pl/sql script using informatica mapping?
What is informatica?
How can we use mapping variables in informatica? Where do we use them?
What are the tasks that source qualifier perform?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Differentiate between source qualifier and filter transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
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 target load order?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What does role playing dimension mean?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
difference between repository database and repository service?
How you know when to use a static cache and dynamic cache in lookup transformation?
