Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 8 Answers
- 14900 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / sri
Bulk mode always create a session log and is used in
session recovery for eg . if we opt for bulk mode, if the
session fails after inserting 9000 rows on total of 10,000
rows (commit interval is after 10,000 rows) then we can
recover 9000 rows and can satrt the session for the rest of
row
In normal mode session log is not created and hence it is
faster than bulk mode .. Session recovery is not possible
in normal mode ..
| Is This Answer Correct ? | 4 Yes | 53 No |
Post New Answer View All Answers
How to delete duplicate row using informatica?
Difference between Data and Index Caches?
What are the informatica performance improvement tips
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How do you set a varible in incremental aggregation
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a mapplet/worklet in informatica?
What is aggregator transformation in informatica?
what are the deliverables?in your project?
How to open an older version of an object in the workspace?
Plz can any one say me how to get the informatica certification materials and dumps
What is data caches/ index caches?
What is pmcmd command?
How to create or import flat file definition in to the warehouse designer?
what is $$$$?
