HI Experts,
What is BULK mode and NORMAL mode, Which one gives better
performance. How? Please Explain with an example...! It
will help's me a lot.
Thanks In advance.
Answer Posted / kumar
Hi Friends,
Normally we have two types of loading. 1, Normal and 2. Bulk.
1 Normal: in this, data will load record by record and the integration service creates database log and is used in session because IS maintain the session log.
2 Bulk: In this, Data will insert Group of records, obviously bulk load will give better performance.
thanks,
kumar
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Informatica Checkpoints
what is unit testing?tell me proceedure
What is the function of look up transformation?
How to do the error handling of if ur source is flatfiles?
Explain the difference between mapping parameter and mapping variable?
What is workflow monitor?
How can we improve session performance in aggregator transformation?
Why filter transformation is an active one?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain the pipeline partition with real time example?
What are the components of Informatica? And what is the purpose of each?
Under what condition selecting sorted input in aggregator may fail the session?
What is difference between a gateway node and worker node?
How to extract the informatica rejected data?
How can we delete duplicate rows from flat files?