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
- 7247 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 |
What is limitations of truncate and load option
Explain the etl program with few examples.
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
without table how to come first record only in oracle?
What is a look up function? What is default transformation for the look up function?
In development project what is the process to follow for an etl developer from day1
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explian the connected and unconnected lookup transformation
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
What is a design?
In which scenario did you used pushdown optimization?
how we can load rejected record's at run time?(not through bad files)
Teradata 
