Interested to Buy Any Domain ? << Click Here >> for more details...
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
- 4 Answers
- 21222 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna
joiner is best because we will make less number of records or dublicate records as master. integration servic create cahce for master table. becaue of that cahce size is small and secarching oricess become easy. in case of lookup its should scane om botom to end it will take more time.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / basha
based on the situation if we need to cache concept we will
use lkp tr ,we doesnot need to caches we use joiner tr
performence wise joiner is better
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / rampriya
Joiner is faster than lookup. Joiner will fetch the data
only once form the database, but the lookup will fetch the
data for each record from the database. So performance wise
joiner is better than lookup.
| Is This Answer Correct ? | 4 Yes | 13 No |
What are the new features of the server manager in the informatica 5.0?
what are the deliverables?in your project?
Which development components of informatica have the highest usage?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
Difference between task flow and linear task flow
How to delete the (flat file) data in the target table after loaded.
what is mapping parameter?
In ur current projectu have done any performance tuning of mappings?
What is the difference between a shortcut of an object and copy of an object? Compare them.
what is the command to get the list of files in a directory in unix?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Teradata 
