Skip navigation
Contact Us
6326 Views 4 Replies Latest reply: Nov 3, 2012 4:49 PM by Chaitanya Thummala RSS
Jai Patidar Newbie 41 posts since
Jun 5, 2008
Currently Being Moderated

Aug 5, 2008 10:13 PM

load type.Bulk Mode and Normal


Hi All,



Can any one tell me wht is diff b/w Buld mode and normal (In Session).



In wht case which one v need to use.Bulk or other one.





Thanks in Advance


Jai

  • Bajrang Lal Sao Novice 54 posts since
    Aug 31, 2007
    Currently Being Moderated
    Aug 12, 2008 12:15 PM (in response to Jai Patidar)
    load type.Bulk Mode and Normal


    Hi,



    Bulk loading improves the performance of a session that inserts a large amount of data to the target database.



    When bulk loading, the Integration Service invokes the database bulk utility and bypasses the database log, which speeds performance. Without writing to the database log, however, the target database cannot perform rollback. As a result, you may not be able to perform recovery


    for more refer Help file

    • Narendra Sarkar Newbie 15 posts since
      Dec 9, 2010
      Currently Being Moderated
      Aug 6, 2012 1:59 PM (in response to Bajrang Lal Sao)
      load type.Bulk Mode and Normal

      Bulk loading uses oracle SQL Loader utility to load data. Bulk loader bypasses DBMS system( redolog and undolog), it directly writes to data file. Transaction can't be rolled back in the case of bulk loading. However, bulk loading is very fast as compare to normal loading.

  • Bhagyaraj D Novice 28 posts since
    Jul 27, 2012
    Currently Being Moderated
    Aug 7, 2012 5:08 AM (in response to Jai Patidar)
    load type.Bulk Mode and Normal

    the above said is true, also, in taget if you are set as primary key then you  cannot use bulk mode.

     

    Bulk mode is trying to update the records in bulk way which should not be any constraints.

  • Chaitanya Thummala Newbie 1 posts since
    Apr 24, 2012
    Currently Being Moderated
    Nov 3, 2012 4:49 PM (in response to Jai Patidar)
    load type.Bulk Mode and Normal

    One more addition to it,If Indexes are defined on target tables,then we can not use Bulk mode.

    If used,Session fails with indicating that indexes are defined.

More Like This

  • Retrieving data ...

Bookmarked By (0)