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 are the fact table & dimensional table in pharmaceutical and hospotal related products???
In warehouses how many schemas are there?
what is the size of u r source(like file or table)?
Is it possible to revert a global repository to local one and why?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Define pmcmd command?
Which are the different editions of informatica powercenter that are available?
What is rank index in rank transformation?
What are the components of workflow manager?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How to join three sources using joiner?
What is joiner change?
How do you take back up of repository?
What differs when we choose the sorted input for aggregator transformation?
Why update strategy and union transformations are active?