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
What are mapplets? How is it different from a Reusable Transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the function of look up transformation?
How we can create indexes after completing the load process?
What are junk dimensions?
Could you explain what is enterprise data warehouse?
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
What is the maplet?
What is the difference between router and filter?
What could be the possible resons of locks by user?
As union transformation gives UNION ALL output, how you will get the UNION output?
can u give example for factless fact table
Explain the etl program with few examples.
Explain in detail scd type 2 through mapping.
What is decode in informatica?