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 / 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 |
Post New Answer View All Answers
What is a router transformation?
What is union transformation in informatica?
difference between repository database and repository service?
is it possible to index the data in cache of lkp transformation ?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
where to store informatica rejected data? How to extract the informatica rejected data?
Informatica Checkpoints
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
explain abt ur project architecture?
How to differentiate between the active and passive transformations?
Why is sorter an active transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How to implement security measures using repository manager?