Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 17616 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 |
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 |
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
What all are steps in up gradation of Informatica server?
"Change cache" in Informatica ?
If you want to create indexes after the load process which transformation you choose?
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
how may sources can be used in a mapping at a time?(limit)
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
Insert else update option in which situation we will use
What are the session parameters?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
What is Index Caches size?
define galaxy repository in informatica
Teradata 
