suresh

• Sep 9th, 2005

 

what is the difference between powermart and power center?

suresh

• Sep 9th, 2005

 

when we go for unconnected lookup transformation?

sangeetha

• Sep 23rd, 2005

 

bulk load is faster than normal load. In case of bulk load informatica server by passes the data base log file so we can not roll bac the transactions. Bulk load is also called  direct loading.

premlahari

 Profile Answers by premlahari 

• Dec 13th, 2005

 

Normal Load: Normal load will write information to the database log file so that if any recorvery is needed it is will be helpful. when the source file is a text file and loading data to a table,in such cases we should you normal load only, else the session will be failed.

Bulk Mode: Bulk load will not write information to the database log file so that if any recorvery is needed we can't do any thing in such cases.

compartivly Bulk load is pretty faster than normal load.

kalam

• Feb 12th, 2006

 

Rule of thumb

For small number of rows use Normal load

For volume of data use bulk load

Ray

• Mar 22nd, 2006

 

also remember that not all databases support bulk loading. and bulk loading fails a session if your mapping has primary keys

hanimi

 Profile Answers by hanimi 

• Apr 28th, 2011

 

bulk load the dwh server bypass the data to the target, in that we have session performance improves.
in normal load data moves the database log file.