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
How many transformations can be used in mapplets.
In warehouses how many schemas are there?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
When do you use sql override in a lookup transformation?
What is the procedure for creating independent data marts from informatica 7.1?
How do you use reject loader.
What are active transformations.
What is option by which we can run all the sessions in a batch simultaneously?
Explain your project of banking domian.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Briefly define reusable transformation?
Where can we find the throughput option in informatica?
What are the various types of transformation?
Global and Local shortcuts. Advantages.