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
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Implementation methodology
What are the different types of repositories created using informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain the shared cache and re-cache?
How many types of sessions are there in informatica.please explain them?
Briefly describe lookup transformation?
How to start a workflow using pmcmd command?
How can a transformation be made reusable?
What is the benefit of partitioning a session?
explain one complex mapping with logic? sales project?
What is informatica?
can we override a native sql query within informatica? How do we do it?
Different circumstance which drives informatica server to expel records?