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
- 21625 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 |
Where is metadata stored?
can we have to do changes in session property when we are dynamically generating target files?
What are session parameters ? How do you set them?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
Differentiate between joiner and lookup transformation?
What are the types of maping in Getting Started Wizard?
What are the reusable transforamtions?
What is the sequence generator transformation in informatica?
how can we check whether a particular cache is static or dynamic?
How to generate a single mapping for both the historical and incremental load.
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
Teradata 
