Situation and Setup of a Historisation in Teradata Vantage Imagine that the time has come to improve your physical data ...

Enhancing Your Teradata Vantage Design with Teradata Historization: A Comprehensive Method

Method 1, avoiding any helper tables or functions which are only available in new releases of Teradata: WITH RECURSIVE NumberRanges(TheNumber,TheString) ...

Two Methods for Generating Number Ranges in Teradata

Have you observed the divergent behavior of the Teradata LIKE operator when applied to a CHAR or VARCHAR data type ...

Why Teradata’s LIKE operator behaves differently for CHAR and VARCHAR columns

Teradata SQL and Advanced GROUPING Functions What advanced GROUPING methods are there in Teradata SQL? – GROUP BY GROUPING SETS– ...

Advanced GROUPING Methods in Teradata SQL: GROUP BY GROUPING SETS, ROLLUP, and CUBE

Introduction Teradata SQL lacks a built-in function to determine the ASCII code of a character. But fear not, for there ...

How to Find ASCII Code of a Character Using Teradata SQL

Teradata internally stores the date as INTEGER. Calculate dates after January 1st, 1900 using this formula: ((year- 1900) * 10000) ...

Efficient Teradata Date Calculations Avoiding INTEGER Values

Teradata DDL – DELETE, don’t DROP To initiate the ETL process on Teradata, a simple approach involves importing data from ...

Teradata DDL Best Practice: Use DELETE Instead of DROP for Efficiency and Resource Management

I made organizing Stored Procedures into Chapters and Steps a principle. These separation points are marked by comments and variables ...

Benefits of Organizing Stored Procedures into Chapters and Steps

TO_NUMBER I have often needed a function to verify whether a character column contains a numeric value. Typically, I have ...

Teradata Built-In Functions: TO_NUMBER, TRUNC, CEILING, FLOOR, LEAST, GREATEST, ROUND

Teradata Development – Keep it simple, stupid! Specialization within the workforce has led to a growing issue, which I have ...

Simplify Teradata Development: Avoiding the Pitfalls of Over-Specialization and Large SQL Statements