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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How you can differentiate between connected lookup and unconnected lookup?

855


What is the different lookup cache(s)?

841


in reporting we add some new objects,how we get the count of the newly added objects to the report

2003


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1003


what is Active lock explain

2581


Enlist the tasks for which source qualifier transformation is used.

807


How can informatica be used for an organization?

928


Explain about Informatica server process that how it works relates to mapping variables?

860


How many ways are there to do 'remove duplicate records in informatica'?

813


Explain target update override in informatica

882


What is meant by pre and post session shell command?

895


Which transformation should we use to normalise the COBOL and relational sources?

1006


How can repository reports be accessed without sql or other transformations?

1000


how many types of dimensions are available in informatica?

777


How do you load only null records into target?

992