Sandhya.Kishan

 Profile Answers by Sandhya.Kishan 

• Apr 17th, 2012

 

1.TPump allows us to load data into tables with referential integrity which MultiLoad doesn't allow.

2.TPpump does not support MULTI-SET tables,but multiple tables can be loaded in the same MultiLoad in mload.

3.Tpump access individual rows with a regular read lock where as mload takes a write lock to access the table.

4.There is no Tpump code within the DBMS, so new features are automatically enabled with Tpump, whereas there are a number of features that we cant use with Multiload

5.Tpump sends the data as part of a statement.Multiload performs better because it sends the data from the host to the DBMS more efficiently.