ravi guturi

• Oct 20th, 2005

 

normal load is the best.

chander165

 Profile Answers by chander165 

• Oct 25th, 2005

 

normal is always preffered over bulk.

rvishnudas

 Profile Answers by rvishnudas 

• 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.

Gokulnath_J

 Profile Answers by Gokulnath_J 

• Nov 8th, 2005

 

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.

rajesh

• Nov 18th, 2005

 

Normal Loading is Better

Rajesh.A

• Nov 18th, 2005

 

Rajesh:Normal load is Better

Dichen

• Nov 24th, 2005

 

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

gazulas

 Profile Answers by gazulas Questions by gazulas

• 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)

vikota

 Profile Answers by vikota 

• 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

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 14th, 2011

 

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..