If we have lookup table in workflow how do you trouble
shhot to increase performance?
- 2 Answers
- 6437 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 |
Can i create a lookup table without cache.
what is Partitioning ? where we can use Partition?
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
what is the difference between mapplet & stored procedure?
what is galaxy repository?
What is the advantage of persistent cache? When it should be used.
How the informatica server increases the session performance through partitioning the source?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
what is data driven?
How can yoU create or import flat file definition in to the warehouse designer?
How can we delete duplicate rows from flat files?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Teradata 
