can you avoid static cache in the lookup transformation? I mean can you
Answer Posted / 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 |
Post New Answer View All Answers
Explain the informatica workflow?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is DR strategy for Informatica project?
What does “tail –f” command do and what is its use as an Informatica admin.
can you please explain me pre session and post session options?
Whats there in global repository
Can we change Dynamic to Static or Persistent cache? If so what happens?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
where to store informatica rejected data?
How does a rank transform differ from aggregator transform functions max and min?
Different sorts of metadata that stores in the storage facility?
How do you convert single row from source into three rows into target?
Different qualification between a related rotate toward the sky and isolates look upward?
On which transformations you created partitions in your project?
What do mean by local and global repository?