What is the difference between Bulk Load and Normal Load

Answer Posted / prasad

Normal Load: Normal load option in session properties will
load records one-by-one and generate log for the informztion.

Bulk load: It will load all records at a time and did not
generate session log for records.. when you enable bulk load
the IS invokes sql loaders and bypass database log.

in normal we can able to recovery session
but bulk load cannot recover the sesion

..correct me if i am wrong

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1869


What are the advantages of informatica?

548


Design a mapping to load a target table with the following values from the above source?

851


Write the advantages of partitioning a session?

726


my source is junk data how will u remove that junk data by using unix please any one replay me

3213






How to load a Dimension ? and how to load a fact table?

931


What is union transformation?

550


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1722


What is the difference between Active and Passive transformation?

606


What is data caches/ index caches?

591


generate date / time dimension in informatica

696


How can one identify whether mapping is correct or not without connecting session?

833


What is decode in static cache?

574


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1592


Global and Local shortcuts. Advantages.

1436