major difference between normal loading and bulk loading?

Answer Posted / ananta mishra

1-normal loading will load data first in log file then load
in target.
but bulk loading load the data directly in target.
2- performance will increase where bulk loading will use.

3-u can't recover data when use bulk loading.so for that we
have to start workflow again.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1082


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

601


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

794


What is event and what are the tasks related to it?

621


Mention a few design and development best practices for informatica?

563






What do you mean incremental aggregation?

628


What is different between the data warehouse and data mart?

630


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1214


Which are the different editions of informatica powercenter that are available?

562


What is the benefit of session partitioning?

601


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

1760


What is sequence generator transformation in informatica?

627


Difference between Target-based loading and constraint-based loading?

558


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1657


How would you join a node to the already existing domain?

683