What is the difference between Narmal load and Bulk load?

Showing Answers 1 - 7 of 7 Answers


  • Sep 9th, 2005

what is the difference between powermart and power center?


  • Sep 9th, 2005

when we go for unconnected lookup transformation?


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


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


  • Feb 12th, 2006

Rule of thumb

For small number of rows use Normal load

For volume of data use bulk load

  Was this answer useful?  Yes


  • Mar 22nd, 2006

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

  Was this answer useful?  Yes


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

  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