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
Answer Posted / vandan
Informatica server issues commit commands as follows as per
your question
15000, 22500, 30000, 37500, 40000
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is the sequence generator transformation in informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Informatica Checkpoints
Where is metadata stored?
Explian the Process of deployment groups in informatica
Briefly define a session task?
What is session task and command task?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain the difference between mapping parameter and mapping variable?
What are the performance considerations when working with aggregator transformation?
I have a flat file, want to reverse the contents of the flat file
What are the types of schemas we have in data warehouse and what are the difference between them?
What is an expression transformation?
Explain the aggregator transformation?
How are the sources and targets definitions imported in informatica designer?