If we have lookup table in workflow how do you trouble
shhot to increase performance?
Answers were Sorted based on User's Feedback
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 |
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 |
How do you recover rows from a failed session
Can we use parameters of parameter file in presession command
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?
What is option by which we can run all the sessions in a batch simultaneously?
What is aggregate cache in aggregator transformation?
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?
What is olap (on-line analytical processing?
what is the exact meaning of domain?
What is fact table? Explain the different kinds of facts.
What are the components of the workflow manager?
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.