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

Explain the use of aggregator cache file?

693


permutations of mapplet

2048


How do you convert single row from source into three rows into target?

616


What are the differences between oltp and olap?

559


In informatica workflow manager, how many repositories can be created?

797






What is a rank transform?

684


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

655


What is flashback table ? Advance thanks

1497


What are the informatica performance improvement tips

629


How to load the data from a flat file into the target where the source flat file name changes daily?

586


Mention a few design and development best practices for informatica?

573


What is xml source qualifier transformation in informatica?

723


How many input parameters can exist in an unconnected lookup?

1022


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

747


Why do you use Mapping Parameter and mapping variable?

1298