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 can we use batches?

0 Answers  


How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, iGate, IBM,


What are the different tools in workflow manager?

0 Answers  


Enlist the various types of transformations.

0 Answers  


Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,






What are the designer tools for creating tranformations?

1 Answers   Informatica,


what are the challenge face in u r project?explain me

1 Answers   TCS, iGate,


my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,


task is running successfully but data is not loded why?

2 Answers  


How can you validate all mappings in the repository simultaneously?

0 Answers  


If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,


can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,






Categories