DWHPro Insights

Transactions

Loading Data into Teradata using Python and Fastload Widely read

Icon of a chrome hammer inside an orange circle over a brick pattern

Create the target table once in a dedicated test schema and leave it empty before loading. The function does not drop an existing table. Use credentials from your environment and validate source widths before FastLoad. The audit tested the loading protocol and stored values with a small deterministic fixture; the 100,000-row random generator below is …

Read more

High-Performance Calculations with Teradata Ordered Analytical Functions Popular

Illustration of a glossy orange database cylinder with data fragments across its surface

For a true calendar-day window, aggregate to one row per department/day and supply missing dates, or use a date-bounded query. With duplicate dates, add a meaningful tie-breaker for a ROWS frame. Adding an ORDER BY or PARTITION BY column can change the result and must preserve the intended business semantics. Teradata employs two distinct approaches …

Read more

Teradata VantageCloud Lake: Architecture and Use Cases Widely read

Illustration of three stacked database storage units of differing heights against abstract chart shapes

Introduction Parallel database architectures have undergone significant advancements over the past four decades, transitioning from shared memory architecture to shared disk architecture and, finally, to the more efficient shared-nothing architecture. Databases designed specifically for cloud environments incorporate elements of shared-disk and shared-nothing architectures. Teradata is a powerful and scalable relational database management system designed to …

Read more

Optimizing Teradata Queries: From No Index to Hashed NUSI Popular

Illustration of a stopwatch dial on an orange paint-splash background

The initial situation without any index In this blog, I will demonstrate how to optimize a query using Teradata’s tools. We will begin with the following test scenario: The data is evenly distributed. To demonstrate the query’s selectivity for the tested indexes we will define later, I assigned a significant portion of rows the same …

Read more

Teradata Rollbacks: Understanding the Impact on Performance and How to Avoid Them Popular

Illustration of a person in a suit standing beside a database cylinder

How to Abort the Teradata Rollback Rollback cancellation can invalidate the table and is a DBA recovery action, not routine tuning. Follow a documented recovery procedure and verify a rebuild/restore path; skew on one AMP does not inevitably stop the entire system. Watch: what happens when you abort a big DELETE This video shows why …

Read more

The Importance of Minimizing Teradata I/O: Understanding Logical vs. Physical IOs and Their Impact on Performance

Illustration of a stopwatch dial on an orange paint-splash background

Why is Teradata I/O so crucial? Minimizing Teradata I/O is a crucial aspect of performance tuning. IOs involve transferring data from storage to main memory, which is essential for Teradata to process data. Transferring data to the main memory is significantly slower than accessing data in the main memory or CPU cache. Minimizing IOs can …

Read more

Understanding Teradata Load Isolation Most read

Illustration of a network graph with circular nodes joined by lines

Isolation Levels and their Impact on Performance & Concurrency Load isolation provides a defined committed view under its supported rules; it is not a blanket serializability or performance guarantee. Feature support and restrictions must be verified for the target deployment. Teradata provides varying degrees of isolation: In the next chapter, we will describe how these …

Read more

Teradata Transactions: Main Characteristics and Best Practices Widely read

Illustration of three stacked database units of differing heights inside a circle

What Are The Main Characteristics Of Transactions in Teradata? The Teradata Mode For Transactions Various techniques exist for composing SQL statements and applying transaction handling. Each approach has unique benefits, drawbacks, and characteristics worth considering. Let’s examine two sequential statements as an illustration: Using Teradata Mode With Explicit Transaction These statements can be executed as …

Read more

Choosing the Right Teradata Data Types Widely read

Illustration of a stopwatch dial on an orange paint-splash background

How Do I Select The Appropriate Data Type In Teradata? Converting data types incurs substantial costs and demands significant CPU resources when dealing with extensive tables. Incorrect data type selection hinders the execution plan. This article will discuss selecting appropriate data types for optimal performance. Consistency in selecting data types across different tables is crucial, …

Read more

Unlocking the Power of Teradata Macros: Features, Creation, and Execution

Icon of a chrome hammer inside an orange circle over a brick pattern

What is a Teradata Macro? A macro executes its statements as a request, with transaction behavior governed by session mode and any enclosing transaction. Do not infer an unconditional commit. Quoting the Subscriber identifier allowed CREATE/REPLACE, EXECUTE and DROP to complete in the fixture. What are the Features of Teradata Macros? How is a Macro …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam