can you avoid static cache in the lookup transformation? I mean can you
Answer / isha
Yes.
Uncheck the 'lookup cache enabled" option. It will become un-cached lookup and will fire query on DB directly... It is not a good idea at all. Cache always increases speed of execution.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are parallel querys and query hints?
How we can create indexes after completing the loan process?
What is transformation?
What are the static cache and dynamic cache in informatica?
How to delete first 3 rows & last 3 rows in target table in informatica
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
When do you use sql override in a lookup transformation?
How to use Normalizer transformation?
What is workflow? What are the components of the workflow manager?
what type of transformation is not supported by mapplets?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
What is informatica powercenter repository?