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

Can you create a flatfile target

3 Answers   ABC,


I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,


waht is dataware house

2 Answers  


How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,


Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers  






If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,


Could you explain what is enterprise data warehouse?

0 Answers  


Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,


my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,


Why update strategy and union transformations are active?

0 Answers  


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

2 Answers  


What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,


Categories