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 / 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 function of look up transformation?
without table how to come first record only in oracle?
What are the databases that informatica can connect to windows?
To import the flat file definition into the designer where should the flat file be placed?
r u done any partitions in ur project?
What is the scenario which compels informatica server to reject files?
Enlist the tasks for which source qualifier transformation is used.
How to go to the older version for a mapping?
What are the new features of informatica 9.x in developer level?
How can we use mapping variables in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
Why union transformation is an active transformation?
Explain lookup transformation is active in informatica
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How can a transformation be made reusable?