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

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  


What is powercenter on grid?

0 Answers  


100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,


Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,


How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  






Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  


What is a parameter When and where do you them when does the value will be created

0 Answers  


any body can say about all versions of informatica ?how many versions ?

2 Answers  


what is work of PUSH DOWN option

2 Answers   Wipro,


explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,


What is the difference Between Mapping parameter and variable

3 Answers   Accenture,


i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,


Categories