from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic
Answer Posted / ajay bhosal
Uncached lookup can give you good performance here but only when your target is properly indexed. Moreover, it's not a good idea to hit the database 100 times and scan huge data volume in the database.
Similar or better performance can be achieved by using Joiner with Sorted Input, but ensure that 100 rows are in master pipeline and the detail pipeline is sorted.
There is no question of using cached lookup.
Answer will be Joiner.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different versions of informatica?
what is the Default Source Option For Update Strategy Transformation?
What is the benefit of partitioning a session?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
what is the difference between informatica6.1 and infomatica7.1
How can you increase the performance in joiner transformation?
What is option by which we can run all the sessions in a batch simultaneously?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Write the unconnected lookup syntax?
Define the various join types of joiner transformation?
What is workflow monitor?
Please let me know how to make encryption and decryption with example?
scenario where i can use only concurrent execution of workflow.
What are the restrictions of union transformation?
What is informatica etl tool?