Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 27349 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
What is a predefined event?
What is dimensional table? Explain the different dimensions.
What is exclusive and normal mode for repository services?
How many ways are there to do 'remove duplicate records in informatica'?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is rank transformation in informatica
What are the advantages of using informatica as an etl tool over teradata?
Separate from an archive server and a powerhouse?
Clarify the utilization of aggregator cache record?
What does update strategy mean, and what are the different option of it?
How to create the source and target database connections in server manager?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are Dimensional table?
How you prepared reports for OLAP?
What are the different types of repositories created using informatica?
