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
- 27549 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
How to join three sources using joiner?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is parallel processing in informatica?
What are active and passive transformations?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the benefit of partitioning a session?
Explain sessions?
Write the program through which the records can be updated?
What is status code in informatica?
Explain pushdown optimization and types in informatica
What does “tail –f” command do and what is its use as an Informatica admin.
Explain scd type 3 through mapping.
What are the limitations of joiner transformation?
How do you use reject loader.
What is lookup transformation?
