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 |
what is diff between grep and find
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
what is the need of session partitioning... how it is useful in real time
How to run a session, which contains mapplet?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is joiner transformation?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
Can we use the mapping parameters or variables created in one mapping into another mapping?
why we use source qualifier transformation?
What is up date strategy and what are the options for update strategy?
Enlist the differences between database and data warehouse.
How can we improve session performance in aggregator transformation?