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
- 2925 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
How to join three sources using joiner? Explain though mapping flow.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain constraint based loading in informatica
What are the reusable transformations?
How you prepared reports for OLAP?
What are the tasks that can be performed using sq?
What is target designer and target load order?
How to do the error handling of if ur source is flatfiles?
How are the sources and targets definitions imported in informatica designer?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What do mean by local and global repository?
What is DR strategy for Informatica project?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Separate from a database, an information bazaar, and an information stockroom?
What is the scenario which compels informatica server to reject files?
