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
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is informatica metadata and where is it stored?
How you can differentiate between connected lookup and unconnected lookup?
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
Explain the features of connected and unconnected lookup.
What is domain in terms of informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
How do you load unique records into one target table and duplicate records into a different target table?
What are the steps involved in the migration from older version to newer version of Informatica Server?
what is the size of u r source(like file or table)?
Enterprise data warehouse your projects phase by phase explain?
How can you validate all mappings in the repository simultaneously?
Differentiate between router and filter transformation?
What is meant by active and passive transformation?
How many transformations can be used in mapplets.