performance wise which one is better in joiner and lookup transformation?why?explain clearly?
- 4 Answers
- 20137 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 |
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
if we have a delimiters at unwanted places in a flat file how can we over come those.
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
Explain pmcmd command usage in informatica
What do you understand by SOA of Informatica?
can we override a native sql query within informatica? Where do we do it?
When you move from devel to prod how will you retain a variable
Which transformation should we use to normalise the COBOL and relational sources?
What is meant by pre and post session shell command?
What is the main difference between a Joiner Transformation and Union Transformation?
expain about the tune parameters?
Teradata 
