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
- 27048 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 are the performance considerations when working with aggregator transformation?
What are the differences between oltp and olap?
What is flashback table ? Advance thanks
What do think which one is the better joiner or look up?
what is SDLC way of code development?
How many dimensions are there in informatica?
Sequence generator, when you move from develoment to production how will you reset
is it possible to index the data in cache of lkp transformation ?
Design a mapping to load a target table with the following values from the above source?
Where do we use mapping variables in informatica?
Explain how to import oracle sequence into informatica?
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
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the different lookup cache(s)?
Tell me about Propagate functions in informatica
