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?
- 2 Answers
- 14450 Views
- Deloitte, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
How can i set break points in debugging mode ? can explain steps please?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
Write the unconnected lookup syntax and how to return more than one column.
What can we do to improve the performance of informatica aggregator transformation?
Where should yoU place the flat file to import the flat file defintion to the designer?
explain abt joiner t/r?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
What is the difference between router and filter?
What is a taget load order?
why we use informatica in our project?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Teradata 
