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

How to update source definition?

0 Answers  


a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,


Tell me one complex query in oracle ?

2 Answers   Satyam, L&T,


Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  


which transformation uses cache?

3 Answers   Keane India Ltd,






My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,


What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,


r u done any partitions in ur project?

0 Answers   TCS,


What are the tasks that source qualifier perform?

0 Answers   Informatica,


what is work of PUSH DOWN option

2 Answers   Wipro,


i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  


What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,






Categories