Roland Wenzlofsky
Effortlessly Loading a CSV File into Teradata using Python
Learn how to easily load a CSV file into a Teradata database using Python with minimal code. No need for complex scripts or ETL tools. Read more.
Negative Impact of Applying Functions to Join Columns in Teradata Joins: Performance Implications and Solutions
Introduction to Apache Spark: A Powerful Solution for Big Data Processing and Analytics
Filter efficiently with Teradata NOS
Teradata NOS facilitates querying data in an S3 object store with ease. To attain maximum performance, partitioning external data is crucial for efficient reading. This article outlines the key considerations for optimal efficiency when reading data from the object store.
To begin, we must establish S3 access by obtaining an
Teradata TD_WhichMax and TD_WhichMin Functions: A SQL Solution for Finding Min/Max Value of a Column with Low Resource Consumption
What is the Teradata TD_WhichMax Function?
Teradata releases new SQL features with each update, providing enhanced functionality and improved performance with reduced resource usage.
We will examine the Teradata TD_WhichMax and TD_WhichMin functions and explore their potential benefits.
These functions retrieve the minimum or maximum value of
Date ranges and business calendars beyond recursion and Teradata SYS_CALENDAR
In a previous article, Roland explained how to use recursion to build a data range without touching a physical table. This time, we explore an alternative approach that avoids recursion at the expense of single-AMP, single-row access. We can use this approach to build both a wide date range as
Maximizing Performance and Space Savings: Teradata Compression Techniques
Teradata strtok_split_to_table, CSVLD, Unpack: Column Splitting in Teradata
Splitting column content can be a challenging task. Teradata provides multiple methods to achieve this, each with unique pros and cons. In this article, we will examine these techniques in detail. To begin, we will generate a table containing sufficient random data to assess every option's efficiency and