performance wise which one is better in joiner and lookup transformation?why?explain clearly?
- 4 Answers
- 19741 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 |
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
my source is junk data how will u remove that junk data by using unix please any one replay me
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
explain different types of modeling.
What are the options in the target session of update strategy transsformatioin?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
How to import oracle sequence into Informatica?
What are set operators in Oracle
explain abt union t/r?
Teradata 
