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 is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Why update strategy and union transformations are active?
What is the difference between Active and Passive transformation?
What does command task mean?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How can you generate reports in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
can u any challenge your project?
How to differentiate between the active and passive transformations?
Explian the Process of deployment groups in informatica
Explain why we use partitioning the session in informatica?
Different circumstance which drives informatica server to expel records?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
design of staging area?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?