Answer Posted / sushma
If you configure lookup TRFM to use dynamic cache, then u
can use only = operator in the lookup condition,whereas LKP
TRFM using static cache can use any relational operator in
the lookup condition.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Informatica settings are available in which file?
which one is better performance wise joiner or look up
Explain scd type 3 through mapping.
What is data caches/ index caches?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is a router transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How can you increase the performance in joiner transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
Explain direct and indirect flat file loading (source file type) - informatica
What is a transaction control transformation?
generate date / time dimension in informatica
What is the cumulative sum and moving sum?
What is transformation?