Teradata
A collection of 307 issues
The Teradata MAPS Architecture – Great Performance with All Rows on One AMP
How to use the Teradata MAPS Architecture?
In an earlier article (link to All Rows on One AMP – By Design), I showed an alternative design for small reference tables, ensuring that all rows in the table are stored on a single Teradata AMP using the Teradata MAPS architecture. The design
Understanding Teradata NOPI Tables: Essential Facts and Performance Benefits
Maximizing Efficiency with Teradata FastExport: A Powerful Tool for Exporting Large Volumes of Data between Teradata Vantage and Client Utilities
Understanding Teradata AMPs and their tasks in a Teradata system
Teradata Roles: Simplifying Rights Management and Improving Performance
Teradata COALESCE Function: Purpose, Syntax, Alternative and Data Types
What is the purpose of the Teradata COALESCE function?COALESCE receives a list of scalars as arguments and returns the first value that is not NULL. If all scalars are NULL, then COALESCE returns NULL.
What is the syntax of the Teradata COALESCE function?SELECT COALESCE(skalar1, skalar2, skalar3,...,skalarN)
Optimizing Teradata Joins: Tips to Reduce Resource Consumption
Joining tables can be costly since each join requires that the rows being joined are on the same AMP. In cases where the two tables possess different primary indices, copying one or both tables' rows may be necessary, which can cause a high number of I/Os in large
Unnecessary IO Elimination – Teradata View Optimization
Data Modeling and the Teradata FSLDM
Overview
* What is A Data Model?
* What are the Major Types of Data Models?
* What is FS-LDM?
* How is FS-LDM Implemented?
Dimensional Modeling
* Dimensional Modeling (DM) is a modeling technique in data warehousing, visually represented as a fact table surrounded by dimension tables.
* Some of the terms commonly used in