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 are the restrictions of union transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How will the document be delivered to me?
What does refresh system mean, and what are its distinctive choice?
What is a sorter transformation?
What are the different transaction levels available in transaction control transformation?
How do we call shell scripts from informatica?
What are pre and post-session shell commands?
Explain the pipeline partition with real time example?
can u give example for factless fact table
how to load rows into fact table in data warehouse
How do you load first and last records into target table?
How do you handle two sessions in Informatica
Explain incremental aggregation in informatica
what is size of u r database?