Suppose we are using a Dynamic Lookup in a Mapping and the commit
Interval set for the tgt is 10000. Then how does the data get
committed in the lookup if there were only 100 roows read from
the src and the dynamic lookup dint have the 100th row in it?
Answer Posted / abhishek singh
First of all can u please tell me whether target is used as
source in this mapping.
If target is used as source in the mapping then commit
interval should be 1.
In other case where target is not used as source then it
could be anything, In your case it will be 10000.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Is it possible to revert a global repository to local one and why?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Define joiner transformation?
define galaxy repository in informatica
What is session task and command task?
Under which circumstances, informatica server creates reject files?
How to generate sequence numbers using expression transformation?
What is primary and backup node?
How can we remove the duplicates from flat file source?
Mention some types of transformation?
Why do you use Mapping Parameter and mapping variable?
How do you load only null records into target? Explain through mapping flow.
What are active transformations.
Write the unconnected lookup syntax?
Performance tuning( what you did in performance tuning)