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 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is song in infrmatica...?

1685


What is domain and gateway node?

702


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

656


what is index?how it can work in informatica

1590


Name at least 5 different types of transformations used in mapping design and state the use of each.?

675






How to delete duplicate row using informatica?

615


Explain why we use partitioning the session in informatica?

617


What is pmcmd command?

677


How to do the error handling of if ur source is flatfiles?

1515


What is update strategy transform?

580


Explain the types of lookup transformation?

577


Write the different tools in the workflow manager?

577


How is union transformation utilized?

574


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1338


COM components can be used in Informatica

1880