Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bulk Load and Normal Load
- 3 Answers
- 13193 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srikanth
Bulk Load: It is preferable when the volume of data is huge
from source system. if we select bulk loading, integration
service doesn't create Database log, that's the reason we
cant perform session recovery.But bulk loading can improve
the performance of session.
Normal Load:If we select normal loading,integration service
create Database log before loading the data into Target.
This database log having the information of last ROWID of
the record for recent load data.it can support session
recovery.
| Is This Answer Correct ? | 7 Yes | 1 No |
Normal Load: Normal load option in session properties will
load records one-by-one and generate log for the informztion.
Bulk load: It will load all records at a time and did not
generate session log for records.. when you enable bulk load
the IS invokes sql loaders and bypass database log.
in normal we can able to recovery session
but bulk load cannot recover the sesion
..correct me if i am wrong
| Is This Answer Correct ? | 4 Yes | 0 No |
How does a sorter cache works?
Explain the flow of data in Iinformatica?
How to prepared lld.can any one tell me detailed explanetion.
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
Is it possible to revert a global repository to local one and why?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
diffrence between command task and control task
what is the method of error handling when session is running?
What is the difference between stop and abort in informatica
What is the capacity of power cube?
Whatis the difference between View and Materialized View ?
What are active transformations? Name them.
Teradata 
