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 |
Can you create a flatfile target
I want skip first 5 rows to load in to target? what will be the logic at session level ??
waht is dataware house
How to create a non-reusable instance of reusable transformations?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
Could you explain what is enterprise data warehouse?
Explain about Informatica server process that how it works relates to mapping variables?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
Why update strategy and union transformations are active?
If we have lookup table in workflow how do you trouble shhot to increase performance?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,