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
What is the format of informatica objects in a repository?
Clarify the utilization of aggregator cache record?
What is a code page?
Define pmcmd command?
What are the different clients of powercenter?
What is union transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is difference between a gateway node and worker node?
What is the need of etl tools?
What are the tasks that source qualifier perform?
expain about the tune parameters?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Please let me know how to make encryption and decryption with example?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?