based on the situation if we need to cache concept we will use lkp tr ,we

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

Question Posted / basha

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is meant by a domain?

1131

Partition, what happens if the specified key range is shorter and longer

2500

How to extract sap data using informatica?

1047

What are the issues you have faced in your project? How did you overcome those issues?

2365

Why update strategy and union transformations are active? Explain with examples.

1243

What is target designer and target load order?

1110

How to create Target definition for flat files?

1229

How are indexes created after completing the load process?

1650

How is union transformation utilized?

1014

In how many ways we can create ports?

1124

How to update a particular record in target with out running whole workflow?

1578

How can you define user defied event?

1032

What are the differences between oltp and olap?

973

What are the different clients of powercenter?

1063

can we override a native sql query within informatica? How do we do it?

1130