If we have lookup table in workflow how do you trouble
shhot to increase performance?
- 2 Answers
- 6789 Views
- I also Faced
- E-Mail Answers
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 |
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
How can you run a session without using server manager?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
HOW DO YOU CONNECT TO REMOTE SERVER ?
Why sorter is an active transformation?
how to convert the .doc docs into .txt format using informatica
What are the types of caches in lookup? Explain them.
What is a filter transformation and why it is an active one?
What is workflow manager?
What do think which one is the better joiner or look up?
what is the drillup & drill down?and use of the drill up and drill down?
Teradata 
