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
- 14415 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 |
What is Java Transformation? what are the uses of it?
what is mean by grouping of condition column in lookup transformation?
what is the look up transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
what is the flow?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
how will you remove the duplicate records from flat file without using sorter?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
what is index?how it can work in informatica
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
explain about unit testing? in real time?
What are the transformations that are not supported in mapplet?
Teradata 
