Link Details

Link 991775 thumbnail
User 1012505 avatar

By teradataguide
via teradata-sql.com
Submitted: Jul 02 2013 / 08:25

TPUMP is a flexible multi-session load utility. The only characteristic of TPUMP that limits its use is its transaction oriented nature. If the situation allows execution of Fastload or Multiload, these utilities will always outperform TPUMP in a large batch operation when measuring Teradata resource consumption and response time. Consideration of TPUMP in a load scenario should occur before that of Fastload or Multiload. Basically TPUMP has none of the disadvantages of Multiload (table locking, load slot usage, single amp operations), Fastload (empty table only, load slot usage), or BTEQ (no checkpointing or restartability).
  • 2
  • 0
  • 87
  • 13

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (2)



Voters Against This Link (0)



    Java EE7
    Written by: Andrew Lee Rubinger
    Featured Refcardz: Top Refcardz:
    1. Design Patterns
    2. OO JS
    3. Cont. Delivery
    4. CI Patterns
    5. CI Tools
    1. Spring Integration
    2. Git
    3. Regex
    4. Java
    5. REST