Somewhere around 2020, the data world quietly arrived at a conclusion that Teradata engineers could have told you in 1984: SQL on a massively parallel architecture is a pretty good way to process large volumes of data. The path to get there was anything but quiet. It involved billions in capital, an entire generation of …
Database features should be compared based on their documented behavior, their operational impact, and the architectural principles behind them. This applies especially to physical optimization structures such as Teradata Join Indexes (JIs) and Snowflake Materialized Views (MVs)—two features often mentioned together during migration planning, yet substantially different in scope and design. The intention of this …
Occasionally, it is necessary to utilize a cursor within a stored procedure to execute specific functionality. I recently encountered a stored procedure that contained a loop with multiple INSERT statements executed through a cursor. This particular cursor was designed to process only a limited number of rows. Despite this, the stored procedure took up to …
Teradata has incorporated several analytical functions from Teradata Aster in its recent releases. Although many of these functions are tailored for web click analysis, Teradata Antiselect has proven valuable for specific applications. What is the Teradata Antiselect function? Teradata’s Antiselect function allows for the reversal of column selection logic. Rather than specifying columns to select, …
Teradata employs two distinct approaches in Ordered Analytic Functions for preparing the data layout necessary for processing. This article explains both approaches and their respective advantages and disadvantages. Teradata Ordered Analytical Functions Teradata Analytic Functions are versatile tools that allow for a wide range of applications. The ability to retrieve previous and subsequent rows is …
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, …
Learn the most essential Teradata SQL statements and functions in this article. From CREATE TABLE to Teradata-specific hashing functions, enhance your data manipulation and analysis capabilities on the platform. Whether you’re a beginner or an experienced user, this guide will help you master Teradata SQL skills.
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.