What is the difference between Bulk Load and Normal Load

Answers were Sorted based on User's Feedback



What is the difference between Bulk Load and Normal Load..

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

What is the difference between Bulk Load and Normal Load..

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

What is the difference between Bulk Load and Normal Load..

Answer / prasad

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

Post New Answer

More Informatica Interview Questions

What is the meaning of up gradation of repository?

0 Answers  


What are multi-group transformations?

0 Answers   Informatica,


i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,


If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,


How to generate sequence numbers using expression transformation?

0 Answers   Informatica,






Explain sessions and how many types of sessions are there?

0 Answers  


What is substr in informatica?

0 Answers  


what is target update override and when we use it?

2 Answers   TCS,


difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,


How to view and Generate Metadata Reports?

1 Answers  


whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,


When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,


Categories