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
- 7 Answers
- 25182 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / benzdev
As per writer buffer here can hold multiple 7500 records
i.e 15000
even though we apply commit points in target the
integration service waits for writter buffer to fill
completely.
Answer is d) 15000,30000,40000
| Is This Answer Correct ? | 24 Yes | 8 No |
Post New Answer View All Answers
Explain the tuning lookup transformation - informatica
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain sql transformation in script mode examples in informatica
What all are steps in up gradation of Informatica server?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Write the advantages of partitioning a session?
which one is better performance wise joiner or look up
Implementation methodology
How to update or delete the rows in a target, which do not have key fields?
differences between service based and product based?
What are the components of the workflow manager?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the designer tools for creating transformations?
What is the reusable transformation?
Explain about cumulative Sum or moving sum?
