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
- 27305 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 the maplet?
When do you use sql override in a lookup transformation?
Make a note of the quantity vaults made in informatica?
Please let me know how to make encryption and decryption with example?
What is a repository? And how to add it in an informatica client?
What is meant by active and passive transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is Cognos script editor?
What's the layout of parameter file (what does a parameter file contain?)?
How can we remove the duplicates from flat file source?
What is the difference between Active and Passive transformation?
What is the use of code page?
What are the databases that informatica can connect to windows?
What is rank index in rank transformation?
Clarify the aggregator change?
