Discuss which is better among incremental load, Normal Load and Bulk load

Editorial / Best Answer


  • Member Since Jan-2006 | Jan 29th, 2006

if supported by the database  bulk load can do the loading faster than normal load.(incremental load concept is differnt dont merge with bulk load, mormal load)

Showing Answers 1 - 10 of 10 Answers

ravi guturi

  • Oct 20th, 2005

normal load is the best.

  Was this answer useful?  Yes


  • Nov 1st, 2005

It depends on the requirement. Otherwise Incremental load which can be better as it takes onle that data which is not available previously on the target.

  Was this answer useful?  Yes

If the database supports bulk load option from Infromatica then using BULK LOAD for intial loading the tables is recommended.

Depending upon the requirment we should choose between Normal and incremental loading strategies.


  • Nov 18th, 2005

Normal Loading is Better

  Was this answer useful?  Yes


  • Nov 18th, 2005

Rajesh:Normal load is Better

  Was this answer useful?  Yes


  • Nov 24th, 2005

RE: incremental loading ? normal load and bulk load?<b...

  Was this answer useful?  Yes


  • Apr 12th, 2011

 Incremental load:
 Incremental means suppose today  we processed 100 records ,for tomorrow  run
u need to extract  whatever the records inserted newly and  updated after previous run  based on   last updated timestamp (Yesterday run) this process called as incremental or delta
Normal load:
 In normal load we are processing entire source data into target with constraint based checking
Bulk load:
 In bulk load with out checking constraints in target we are processing entire source data into target

  Was this answer useful?  Yes

It's totally depends upon the requirement. generally bulk load is faster caz it won't write the data to database logs so we can't do session recovery where as in normal load it is very slow comparing to bulk but the advantage is we can do session recovery..

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions