Understanding Teradata Nodes in Parallel Systems: Architecture and Scalability
Learn about Teradata Nodes - Linux systems packed into cabinets with multicore CPUs, memory, and parallel database extension software (PDE).
AI & Data Engineering
A collection of 53 issues
Effective Teradata Performance Optimization: A Guide to Measuring Improvements
Optimizing Teradata performance can be time-consuming and unpredictable. Before starting, it's crucial to define clear goals and measure improvements using absolute criteria like CPU usage and disk access. In this article, we'll explore the areas that can be optimized in a typical Teradata Data Ware
Teradata Access Rights: Implicit, Explicit, Inherited, and Automatic
Learn about the different types of access rights in Teradata, including implicit, explicit, inherited, and automatic privileges, and how they are granted to owners and creators of database objects.
Teradata SQL Assistant: Usage, Exporting CSV Files, and Connecting to the Teradata Database via CLI or ODBC
Discover the powerful capabilities of Teradata SQL Assistant, a user-friendly interface for managing and querying data in the Teradata database environment. Learn how to connect and export CSV files, and explore popular alternatives. Plus, find out how to access it for free with Teradata Express.
A Guide to Teradata SQL: Features, Optimization, and Queries
Discover the power and unique features of Teradata SQL, the dialect of SQL used within Teradata's large-scale data warehousing and analytics platform. Learn about its differences from standard SQL and how to run queries using Teradata SQL Assistant and BTEQ.
Teradata OLAP Functions: A Systematic Approach to Understanding Window Aggregates
Learn how to work with Teradata OLAP Functions in your data warehouse applications. This systematic approach covers five key design decisions.
Mastering the Teradata CEILING Function
Introduction
To round up decimal values in Teradata, use the CEILING function. It is efficient and accurate. This blog post will show how to use the CEILING function in Teradata to simplify data processing tasks.
Understanding the Teradata CEILING Function
The CEILING function in Teradata is a built-in mathematical function
Understanding the Teradata TRIM Function: A Guide to Removing Spaces and Characters from Strings
Learn how to improve your data quality and consistency with the Teradata TRIM function. Remove unwanted spaces and characters for more accurate analysis.
How to Use the Teradata CURRENT_DATE Function for Efficient Querying
Learn how to enhance the efficiency and potency of Teradata queries using the CURRENT_DATE function. Discover how to filter data and calculate time intervals with ease.
Improving Teradata Load Performance: Choosing the Right Loading Method
Learn how to optimize your Teradata Load Performance by choosing the right loading method per table. Bulk loads for large tables and transactional loads for small ones. Find out more in this article.