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
- 27301 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / baby
b
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
what is index?how it can work in informatica
What is a shortcut and copy in Informatica and how two are different with each other?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is aggregate cache in aggregator transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How would you join a node to the already existing domain?
Differentiate between a database and data warehouse?
Explain the code page compatibility?
Explain how to import oracle sequence into informatica?
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
Explain lookup transformation is active in informatica
What are the modules in Power Center
What is a connected transformation?
