Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bulk Load and Normal Load
- 3 Answers
- 13111 Views
- TCS, I also Faced
- E-Mail Answers
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 pre and post-session shell commands?
What is the scenario which compels informatica server to reject files?
Separate from an archive server and a powerhouse?
How do you take back up of repository?
How can you increase the performance in joiner transformation?
What is the Process to creating lookup transformation in informatica
What are roles and groups and benefits of using them?
Briefly define reusable transformation?
What do you mean by worklet?
Enlist the advantages of informatica.
What is the need of etl tools?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is expression transformation?
What are the components of Informatica? And what is the purpose of each?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
