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 …
Teradata Secure Zones I’ve had a few conversations recently with different customers about the “Secure Zones” optional feature added in Teradata 15.10. There is a fair amount of misunderstanding about what this feature offers and does. This article aims to provide some clear information for anyone considering using this feature. Before I cover that, let …
Introduction to the Teradata Sliding Window Merge Join DWH Pro thoroughly analyzes the Teradata sliding window merge join, which has limited available information. Our extensive research provides valuable insights into this process. To understand the Teradata sliding window merge join, we must first review the join algorithms used in the conventional merge join. This will …
As always, when something comes to the attention of a larger number of people, some embrace it, some frown. We were asked to dissociate the name of this website from the term Teradata. We do so to avoid any future misunderstanding, irrespective of any admission of fault. You will find us at www.dwhpro.com from now …
A Teradata Show Table Proxy for Full DDL Recreation from DBC Throughout my recent development activities, an old desire became relevant again. It goes as follows: Can one write a query that recreates the entire DDL of a table out of dbc views or tables alone? Put differently, can I write my Teradata show table …
Introduction to Teradata Physical Storage In the second part of this series on Teradata Physical Storage, let me take over from Roland to continue where we stopped in part 1. We will enter the world of data blocks and dive deeper into the sequence of actions and consequences for the lives of rows populating data …
Over the years, numerous debates have emerged concerning the superior performance of specific statements: Many personal experiences are often shared but tend to misattribute causality. People usually construct a single test scenario and extrapolate sweeping conclusions from it. The speculation has ceased. Herein lies the truth: The validity of these statements hinges on the data’s …
Introduction to Teradata Data Types and Data Modeling Suppose you work in a well-organized environment where diligence and discipline prevail and significant effort is put into designing things right in the beginning. In that case, the following post might seem outlandish to you. Else, read on. In a more “experimental” table design landscape, you will …
For various reasons, we may need to switch our Teradata historisation from snapshot tables to a start date/end date logic table, which I usually call a change history, as only changes trigger a historisation. A principal motivation for such a move away from a daily snapshot table could be space restrictions. Whatever the reason may …
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.