Loading a text file into a Teradata database can be arduous without the use of intricate scripts. However, generating TPT ...

Effortlessly Loading a CSV File into Teradata using Python

Introduction Applying column joins in Teradata using functions may indicate a flawed data model, potentially violating the first normal form. ...

Negative Impact of Applying Functions to Join Columns in Teradata Joins: Performance Implications and Solutions

Introduction Processing and analyzing large volumes of data quickly and efficiently is essential in today’s data-driven world. Apache Spark, an ...

Introduction to Apache Spark: A Powerful Solution for Big Data Processing and Analytics

Teradata NOS facilitates querying data in an S3 object store with ease. To attain maximum performance, partitioning external data is ...

Filter efficiently with Teradata NOS

What is the Teradata TD_WhichMax Function? Teradata releases new SQL features with each update, providing enhanced functionality and improved performance ...

Teradata TD_WhichMax and TD_WhichMin Functions: A SQL Solution for Finding Min/Max Value of a Column with Low Resource Consumption

In a previous article, Roland explained how to use recursion to build a data range without touching a physical table. ...

Dates ranges and business calendars beyond recursion and Teradata SYS_CALENDAR

Introduction to Teradata Compression Note: Teradata Block Level Compression is now permanently enabled and cannot be turned off. Nonetheless, this ...

Maximizing Performance and Space Savings: Teradata Compression Techniques

Splitting column content can be a challenging task. Teradata provides multiple methods to achieve this, each with unique pros and ...

Teradata strtok_split_to_table, CSVLD, Unpack: Column Splitting in Teradata

This article compares the index types in SQL Server and Teradata. It can benefit those transitioning between the two platforms ...

Comparing Index Types of SQL Server and Teradata: Clustered vs Row Partitioning, Non-clustered vs NUSI, USI, Join Index, and More