Business Intelligence And Data Warehousing Software Directory

Teradata TPump Tutorial
Preview:
Details: The Teradata tutorial presentation of using Teradata TPump in an Active Data Warehouse Environment shows the use, features and architecture of using TPump in great detail. It outlines the reasons why TPump is suitable for active datawarehousing and refers to the key TPump script variables to boost loading performance. The presentation lists the Best Practices of using TPump and presents a few sample TPump scenarios with the proposed configuration settings.

Use of the following Teradata TPump features is deeply analyzed:
  • TPump PACK Factor - TPump multi-statement request buffer
  • TPump Sessions - advices on setting the number of database connections and number of TPump concurrent sessions
  • TPump SERIALIZE - input records partitioning consideration and impacts of serialization
  • TPump deadlock handling and checkpointing
  • TPump ROBUST and TPump IGNORE DUPLICATE ROWS
    		•
    Address:
    Categories: TERADATA TUTORIALS