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
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the uses of etl tools?
How do you take back up of repository?
What will be the approach?
How to update or delete the rows in a target, which do not have key fields?
What is workflow monitor?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
tell me 5 session failure in real time how can you solve that in your project?
What is a filter transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are the new features of informatica 9.x at the developer level?
What is data transformation manager process?
Can informatica load heterogeneous targets from heterogeneous sources?
How many input parameters can exist in an unconnected lookup?
How would you join a node to the already existing domain?