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 / baby
b
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How we can create indexes after completing the loan process?
Explain what transformation and how many are there in informatica?
What are the main issues while working with flat files as source and as targets ?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is the commit type if you have a transaction control transformation in the mapping?
How big was your fact table
What is native users?
According to his methodology what all you need before you build a datawarehouse
How many numbers of sessions can one group in batches?
What are the limitations of joiner transformation?
Write the prerequisite tasks to achieve the session partition?
Can we override a native sql query within informatica?
What is dimensional table?
Slowly changing dimensions, types and where will you use them
What is the difference between STOP and ABORT options in Workflow Monitor?