performance wise which one is better in joiner and lookup
transformation

Answers were Sorted based on User's Feedback



performance wise which one is better in joiner and lookup transformation..

Answer / sbvprasad

Jioner T/r is better.

Is This Answer Correct ?    2 Yes 0 No

performance wise which one is better in joiner and lookup transformation..

Answer / ramesh

Joiner

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  


I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,


How to delete duplicate records in a flat file source?

2 Answers  


As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  


when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  






SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,


can session assigned multiple mappings or not?

2 Answers   Zensar,


What is the difference between router and filter?

0 Answers  


Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  


what is mapping parameter and mapping variables

1 Answers   BirlaSoft,


How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,


Explain the flow of data in Iinformatica?

1 Answers  


Categories