What is the difference between Bulk Load and Normal Load

Answer Posted / guest

Bulk loading,improves the performance of a session that
inserts a large amount of data to the target database.When
bulk loading, the Integration Service bypasses the database
log, which speeds performance. Without writing to the
database log, however, the target database cannot perform
rollback.As a result, you may not be able to perform recovery.

In normal load the databse log is not bypassed and therefore
the target databse can recover from an incomplete session.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are mapplets? How is it different from a Reusable Transformation?

607


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1939


What is the function of look up transformation?

623


How we can create indexes after completing the load process?

585


What are junk dimensions?

608






Could you explain what is enterprise data warehouse?

534


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4286


What is the maplet?

595


What is the difference between router and filter?

627


What could be the possible resons of locks by user?

644


As union transformation gives UNION ALL output, how you will get the UNION output?

616


can u give example for factless fact table

5472


Explain the etl program with few examples.

521


Explain in detail scd type 2 through mapping.

583


What is decode in informatica?

634