Interested to Buy Any Domain ? << Click Here >> for more details...
If we have lookup table in workflow how do you trouble
shhot to increase performance?
- 2 Answers
- 7226 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 |
where is the reject loader .
what are cost based and rule based approaches and what is the difference?
How to send duplicates to one target and unique rows to one target?target is empty
What is a surrogate key?Why we use it in a mapping?Pl give an example.
how DTM buffer size and buffer block size are related
how did u understand business requirement?
any body can say about all versions of informatica ?how many versions ?
Can we use parameters of parameter file in presession command
expain about the tune parameters?
Different circumstance which drives informatica server to expel records?
what is scd?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
Teradata 
