performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Answer Posted / 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 |
Post New Answer View All Answers
permutations of mapplet
what is unit testing?tell me proceedure
How would you join a node to the already existing domain?
How can we handle two sessions in informatica?
Differentiate between a database and data warehouse?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the types of caches in lookup?
Sequence generator, when you move from develoment to production how will you reset
What is a joiner transformation?
Write the unconnected lookup syntax?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Performance tuning in UNIX for informatica mappings?
In informatica workflow manager, how many repositories can be created?
How we can create indexes after completing the load process?
How do you convert single row from source into three rows into target?