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 |
Where do you create/define mapping parameter and mapping variable?
What the difference is between a database, a data warehouse and a data mart?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
How can we improve session performance in aggregator transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Can we insert ,update ,delete in target tables with one update strategy tran.?
what is diffrence b/w joner and union transfermation
Define filter transformation?
Tell me about informatica architecture.
How many numbers of sessions can one group in batches?
What is the Rankindex in Ranktransformation?