major difference between normal loading and bulk loading?

Answer Posted / seshudwh

in in normal loading: one row complete commit. connect to
tgt table.
bulk loading: first row commit second row........commit all
rows at a time connect to tgt table.

Is This Answer Correct ?    0 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are 3 tech challenges/ common issues you face?

1887


What is the difference between informatics 7x and 8x and what is latest version?

541


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1915


Quickly characterize reusable change?

687


What is informatica etl tool?

550






how to create user defined function (udf) in informatica

783


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1697


What is difference between a gateway node and worker node?

621


Explain lookup transformation in informatica

644


What is the different lookup cache(s)?

610


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


What is mapplet in informatica?

592


What are the types of schemas we have in data warehouse and what are the difference between them?

520


What is workflow? What are the components of the workflow manager?

637


Define sessions in informatica etl?

615