Teradata DDL Best Practice: Use DELETE Instead of DROP for Efficiency and Resource Management
Learn why you should opt for DELETE instead of DROP when it comes to Teradata DDL. Avoid locking dictionary tables and conserve resources.
fastload
Teradata Utilities: Fastload, Multiload, BTEQ, and TPump
Learn about Teradata’s load utilities, which can be divided into two groups: those that bypass the transient journal and those that use it. Depending on your requirements, you may choose to load data either way. This article offers advice on how and when to use each tool, including BTEQ, TPump, Fastload, Multiload, and the Teradata Parallel Transporter (TPT). Find out which tool is most efficient for your data quantity and row size.
Improving Teradata Load Performance: Choosing the Right Loading Method
Learn how to optimize your Teradata Load Performance by choosing the right loading method per table. Bulk loads for large tables and transactional loads for small ones. Find out more in this article.
Teradata FastLoad: Bulk Load Your Data Efficiently
Discover the power of Teradata FastLoad – the bulk load utility that efficiently loads vast amounts of data, bypassing the transient journal. Learn more here.
Teradata TPump: What it is and How it Facilitates Real-Time Data Updates
Discover Teradata TPump, the real-time loading tool for transactional systems. TPump loads one row at a time, allowing concurrent INSERTs and UPDATEs using row hash locks. With TPump, you can throttle statement rates and execute DML functions, all while bypassing some of the limitations of bulk loading with Fastload or Multiload. Learn about TPump’s performance and limitations, as well as monitoring and error handling. Check out a sample script to get started with Teradata TPump.
Teradata Vantage now available in AWS, Microsoft Azure, and Google Cloud Storage with Teradata Native Object Store (Teradata NOS)
Teradata Vantage has also made its move into the public cloud. Teradata Vantage is now available in AWS, Microsoft Azure, and Google Cloud Storage. It is worth noting that the same Teradata software runs on these three major cloud providers. This makes it relatively easy to run Teradata on-premise and in these 3 different public …