BLC, Row Level Partitioning, and Datablock Size Tuning In this article, we will learn how block-level compression, row-level partitioning, and selection of the appropriate data block size can be used to influence the Teradata table size and, thus, performance. We will create a test scenario based on a customer master table loaded daily. We will …
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 allows for single-AMP retrieval …
The Essential Facts About NOPI Tables in Teradata Teradata NOPI Table Limitations No SET tables allowed No Identity columns allowed No Row-Level Partitioning allowed No UPDATE, MERGE INTO, or UPSERT allowed No Permanent Journaling is possible It can’t be defined as Queue Tables No UPDATE triggers allowed No Hash Index allowed No Multiload, as its …
Teradata FastExport is a powerful tool for rapidly moving large volumes of data between Teradata Vantage and client utilities. This tool uses multiple sessions to export data to a mainframe-attached or network-attached file quickly. To execute Teradata FastExport, SQL statements in the FastExport script are executed. The tool has two export modes: RECORD and INDICATOR. …
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 tables. The Teradata Optimizer can select from …
Summary Today I will show you how to identify the source problem to tune the query’s performance utilizing the unnecessary amount of IO, the UII indicator, and how the WHERE clause placed on a VIEW is evaluated. This case shows that the WHERE clause placed on VIEW for 2 Partitioned tables resulted in excessive …
Overview Dimensional Modeling SCHEMAS Relational Data Model The Relational Database Model can also perform relational algebra operations, such as Select, Intersection, Product, Union, Difference, Project, Join, Division, Merge, etc. Operations on the Relational Database Model are facilitated with the help of different conditional expressions, various key attributes, pre-defined constraints, etc. For example, selection of information …
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.
