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
- 7347 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 |
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
can session assigned multiple mappings or not?
What can we do to improve the performance of informatica aggregator transformation?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
What are the types of lookup?
How to implement security measures using repository manager?
Explain dynamic target flat file name generation in informatica
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
what are presession,postsession success and postsession failure commands ?
What is the Difference between sorter and aggregator?
What is the need for an etl tool?
Teradata 
