If we have lookup table in workflow how do you trouble
shhot to increase performance?
Answer Posted / 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 |
Post New Answer View All Answers
What is data transformation manager process?
Explain in detail scd type 2 through mapping.
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
In which transformation you cannot drag ports into it?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is the advantage of informatica?
What is dimensional table? Explain the different dimensions.
Define sessions in informatica etl?
How to generate sequence numbers using expression transformation?
Design time, run time. If you don't create parameter what will happen