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

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

Answer / imran

The dynamic lookup cache will be updated in real-time as each row is processed, independent of the target commit interval. The target commit interval only affects when the data is committed to the target table, not when the dynamic lookup cache is updated. Thus, the dynamic lookup will contain the 100th row immediately after it is processed, even though the target table commit interval is not reached.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Explain about HLD and LLD ?

16 Answers   Accenture,


i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,


What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,


i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,


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?

8 Answers   BRAD, TCS,






What are Dimensional table?

0 Answers   Informatica,


What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  


can you use flat file for lookup table?why?

2 Answers   HCL,


Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  


When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,


Explain the mapping variable usage example in informatica

0 Answers   Informatica,


HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  


Categories