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?

Answers were Sorted based on User's Feedback



Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000..

Answer / 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

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000..

Answer / akash

The cache data should not get impacted in this scenario. The commit interval is a target property.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

When do you use sql override in a lookup transformation?

0 Answers  


How many number of sessions can one group in batches?

0 Answers  


which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,


How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,


WHat all joins are there in Source Qualifier?

1 Answers  






My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,


What are two types of processes that informatica runs the session?

2 Answers  


difference between stop and abort

2 Answers  


following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,


How to display First letter of Names in Caps?

7 Answers  


what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,


If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,


Categories