Vamsi Krishna.K

• Oct 1st, 2006

 

Hello,

when we try to load data in bulk mode, there will be no entry in database log files, so it will be tough to recover data if session got failed at some point. where as in case of normal mode entry of every record will be with database log file and with the informatica repository. so, if the session got failed it will be easy for us to start data from last committed point.

Bulk mode is very fast compartively with normal mode.

we use bulk mode to load data in databases, it won't work with text files using as target, where as normal mode will work fine with all type of targets.

srinivas vadlakonda

• Oct 11th, 2006

 

in case of bulk for group of records a dml statement will created and executed

but in the case of normal for every recorda a dml statement will created and executed

if u selecting bulk performance will be increasing

sn3508

 Profile Answers by sn3508 

• Oct 26th, 2006

 

Bulk mode is used for Oracle/SQLserver/Sybase.  This mode improves performance by not writing to the database log.  As a result, when using this mode recovery is unavailable.  Further, this mode doesn't work when update transformation is used and there shouldn't be any indexes or constraints on the table.  Ofcourse, one can use the pre-session and post-session SQLs to drop and rebuild indexes/constraints.