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
- 21291 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 is data driven in informatica
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
Enlist the advantages of informatica.
what is the incremental agrrigation?
Explain the shared cache and re-cache?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
When do you use mapping parameters? (In which transformations)
What are the connected or unconnected transforamations?
How can you run a session without using server manager?
How can i set break points in debugging mode ? can explain steps please?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
Teradata 
