DWHPro Insights

Transactions

Teradata Referential Integrity: What it is and Why You Need it for Data Consistency and Performance Popular

Illustration of a dense isometric network of connected data nodes

Introduction to Teradata Referential Integrity Teradata implements 3 Types of Referential Integrity. 1. What is Standard Referential Integrity? The Standard Referential Integrity checks every Row INSERT, DELETE, or UPDATE immediately to ensure referential integrity. A reference index sub-table is required for referential integrity. Violation of referential integrity results in the failure of execution and generates …

Read more

Maximizing Performance with Multiple Teradata Sessions Popular

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

Teradata Sessions explained in a few Sentences Example 1: Multiple Sessions which do not improve performance Multiple sessions can improve throughput for compatible all-AMP scans or independent tables as well as rowhash access. Benefit depends on workload concurrency and resource contention, not a universal fewer-than-all-AMP rule. Example 2: Multiple Sessions which do improve performance In …

Read more

Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations Popular

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

Teradata Table Design Checklist As creating tables is a frequent task, I deemed it necessary to provide a checklist. 1. Primary Index Or NOPI Table? The Primary Index serves multiple purposes, primarily functioning as the primary access path to the data and being optimized for an even distribution of rows. However, designing a table without …

Read more

Teradata Architecture: How Shared-Nothing Parallelism Works Widely read

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

Teradata Query Parallelism Teradata can execute scans, joins, sorts and aggregations in parallel. The chosen plan determines how many AMPs participate; a primary-index lookup can use one AMP, and dependencies may serialize parts of a request. 🎓 Prefer video? Lecture 2 of my Udemy course Teradata Performance Tuning in Practice, “Shared-nothing parallelism: nodes, PEs and …

Read more

Achieve Incredible Teradata Join Performance

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

Executive summaryGUEST POST BY ARTEMIY KOZYR Today I shed some light on how Data Warehousing lies at the core of Retail Banking operations. We will see the actual case of vital marketing process malfunction and dive deep under the surface level to comprehend data alchemy technical issues. You will learn how to approach such issues, …

Read more

Teradata Transient Journal: How It Protects Transactions Against Failures and Deadlocks Most read

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

Learn about the Teradata Transient Journal, a crucial component for ensuring data integrity and protecting against system failures. This dictionary table is managed by each AMP, containing rows copied before changes are made to a transaction. If a transaction fails, the journal is used to roll back and restore the affected table rows. Discover ways to minimize journaling and improve performance, including BTEQ tricks and using load utilities. Find out how to avoid system-level errors and ensure there is always enough permanent space in the DBC database.

Protected by Security by CleanTalk and CleanTalk Anti-Spam