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

How do you recover rows from a failed session

1 Answers  


Can we use parameters of parameter file in presession command

1 Answers   Wipro,


i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,


What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,


What is aggregate cache in aggregator transformation?

0 Answers   Informatica,






we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,


What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,


What is olap (on-line analytical processing?

0 Answers  


what is the exact meaning of domain?

3 Answers  


What is fact table? Explain the different kinds of facts.

0 Answers  


What are the components of the workflow manager?

0 Answers  


How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,


Categories