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
According to his methodology what all you need before you build a datawarehouse
What is olap (on-line analytical processing?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is degenerated dimension?
Briefly explain the aggregator transformation?
Explain the different dimensions.
Write the advantages of partitioning a session?
What is the Rank index port in Rank transformation?
How do you handle two sessions in Informatica
What are the tasks that can be performed using sq?
How to do the error handling of if ur source is flatfiles?
How can we handle two sessions in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
whats the logic to load the lower level of granularity of data to fact table.
How to load last n records of file into target table - informatica