If we have lookup table in workflow how do you trouble
shhot to increase performance?

Answers were Sorted based on User's Feedback



If we have lookup table in workflow how do you trouble shhot to increase performance?..

Answer / deepak aggarwal

You can calculate the size of lookup cache file needed
from number of rows and colulmn width needed. You can
increase Cache file size for good performance.

Is This Answer Correct ?    1 Yes 0 No

If we have lookup table in workflow how do you trouble shhot to increase performance?..

Answer / priya

There are 2 ways :
1. Create a persistant cache
2. Add the lookup table in SQ make it outer joined

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


How do you take back up of repository?

0 Answers  


How to improve the session performance in informatica?

3 Answers   Accenture,


why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,


wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  






My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  


Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  


what is diffrence b/w joner and union transfermation

6 Answers  


On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  


One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 Answers  


what are the settiings that u use to cofigure the joiner transformation?

2 Answers  


Categories