327 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.
BLC, Row Level Partitioning, and Datablock Size Tuning The sizes and diagrams below are historical observations: the original data, allocation and effective BLC policy are unavailable, so they have not been reproduced. In this article, we will learn how block-level compression, row-level partitioning, and selection of the appropriate data block size can be used to …
For a history table, ref_code alone cannot be unique when several versions of a code must coexist. The large-table example therefore uses a nonunique primary index. Define any required version uniqueness separately, and enforce the rule for identifying the current row. How to use the Teradata MAPS Architecture? In an earlier article (link to All …
The Essential Facts About NOPI Tables in Teradata Historical NoPI restrictions: check the installed release No SET tables allowed No Identity columns allowed Row-level partitioning is supported for appropriate NoPI table definitions; check the release-specific restrictions. UPDATE is supported: it changed both fixture rows on Teradata Database 20.00.28.81. Check MERGE and other operation restrictions separately …
Teradata FastExport is a powerful tool for rapidly moving large volumes of data between Teradata Vantage and client utilities. This tool uses multiple sessions to export data to a mainframe-attached or network-attached file quickly. To execute Teradata FastExport, SQL statements in the FastExport script are executed. The tool has two export modes: RECORD and INDICATOR. …
The components around the AMP are covered separately: how the PE, BYNET and AMP divide the work and a short overview of the architecture.
Summary Today I will show you how to identify the source problem to tune the query’s performance utilizing the unnecessary amount of IO, the UII indicator, and how the WHERE clause placed on a VIEW is evaluated. A WHERE predicate on a view can be pushed into underlying operations. The historical case requires its …
Overview Dimensional Modeling SCHEMAS Relational Data Model The Relational Database Model can also perform relational algebra operations, such as Select, Intersection, Product, Union, Difference, Project, Join, Division, Merge, etc. Operations on the Relational Database Model are facilitated with the help of different conditional expressions, various key attributes, pre-defined constraints, etc. For example, selection of information …
Introduction In modern business, prompt response to opportunities and issues is crucial. Detect and collect business events for prompt processing, generating either an alert for a front-line user or an update message for an operational system. Teradata parallel database triggers handle live events precisely. A dashboard function checks the queue table for significant events every …
We count visits without cookies and without storing anything on your device. With your permission, we also use Google Analytics for our Google Ads integration and remember which campaign brought you here. We do not record sessions. You can decline and still use the site. Privacy details.
