Avoid data warehouse project failures by choosing the right data model. In this article, we explore denormalization techniques for when it makes sense, including repeating groups, prejoins, and derived information. We also discuss alternatives to denormalization, such as Global Temporary Tables and Volatile Tables. Remember, denormalization can improve performance but has significant drawbacks and should be used only when necessary.
Learn about the Teradata parsing engine’s tasks and how it impacts overall system performance. Find out how to clean up the DBC. AccessRights table to improve parsing times in this informative article.
Learn what a Teradata Query Band is and how it can be used to optimize queries in a Teradata system. Discover how to set, update, and read query bands, and how to use them for performance tuning. Find out what to consider when creating a query band in Teradata.
Learn how Teradata and Snowflake minimize IOs to enhance performance. Teradata uses row partitioning while Snowflake relies on micro-partitions.
The Teradata TO_CHAR Function Utilize the Teradata TO_CHAR function to: This is an example of a numeric expression argument, which can be any of the following data types: BYTEINT, SMALLINT, INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT/REAL/DOUBLE PRECISION, or NUMBER. The format string, which must be of type CHAR or VARCHAR, represents the second argument (Further information on …
1. Avoid multiple Joins to the same table Reducing the number of joins to a table is crucial, as each additional join could lead to a full table scan or index access. This can be accomplished by implementing subqueries, volatile tables, or ordered analytical functions. This example showcases applying an ordered analytical function to attain …
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 …
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 …
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Miami, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.