select the properties of TPUMP
-
It is possible to stipulate how many updates may occur per minute
-
It is possible to have tpump running in the background all the time and just control its flow rate
-
It can load upto 60 tables at a time if using a single source
-
It can be stopped any time and all locks dropped or released with no ill consequences.
-
it uses macro to run the SQL statements
-
It has more error tollerance than FL and ML
Tpump offers flexible real-time loading: configurable update rates (A), continuous background operation with flow control (B), support for up to 60 target tables from one source (C), safe stoppability without lock issues (D), and efficient SQL execution via macros (E). It is not designed for the extensive error handling that Multi Load provides.