can you avoid static cache in the lookup transformation? I mean can you
- 1 Answers
- 2344 Views
- I also Faced
- E-Mail Answers
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
While migrating the data from one environment to another environment how would you manage the connections?
What is the Rank index port in Rank transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How do you remove duplicate records in informatica? And how many ways are there to do it?
How to call shell scripts from informatica?
Informatica Checkpoints
What is a code page?
What is InformaticaPowerCenter?
What is complex mapping?
How do you change a non-reusable transformation to reusable transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How do you convert single row from source into three rows into target?
Explain sql transformation in script mode examples in informatica
What are data-driven sessions?
Slowly changing dimensions, types and where will you use them
