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

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2293


How do you load alternate records into different tables through mapping flow?

1290


What is different between the data warehouse and data mart?

630


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

597


What are session parameters ? How do you set them?

1375






What is a grid in Informatica?

605


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1656


Please let me know how to make Data masking in informatica..

1267


Explain load alternative records / rows into multiple targets - informatica

681


What is sq transformation?

660


Differentiate between Load Manager and DTM?

1663


How might one distinguish in the case of mapping is right or not without associating session?

640


What are junk dimensions?

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.

1206


Explain about cumulative Sum or moving sum?

618