Interested to Buy Any Domain ? << Click Here >> for more details...
can you avoid static cache in the lookup transformation? I mean can you
- 1 Answers
- 2937 Views
- I also Faced
- E-Mail Answers
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 |
How do you promote a non-reusable transformation to reusable transformation?
Tell me about informatica architecture.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
Explain constraint based loading in informatica
How to call shell scripts from informatica?
What if the source is a flat-file?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
how will you remove the duplicate records from flat file without using sorter?
what is correlated query?
How can u work with remote database in informatica?did you work directly by using remote connections?
Teradata 
