Executive summaryGUEST POST BY ARTEMIY KOZYR Today I shed some light on how Data Warehousing lies at the core of Retail Banking operations. We will see the actual case of vital marketing process malfunction and dive deep under the surface level to comprehend data alchemy technical issues. You will learn how to approach such issues, …
Become a Teradata Vantage expert by downloading our new Android app for free from the Google Play store and practicing.
Multivalue compression and null indication serve distinct purposes yet share a common objective of gathering data on the values of each row’s columns. To conserve space, Teradata utilizes presence bytes to retain information on multivalue compression and nullability. The alert reader might recognize that the name “presence byte” indicates NULL values. In earlier releases of …
The Optimizer typically excels in utilizing statistics, yet examining the execution plan and cardinality estimations can sometimes be beneficial. Since Teradata 14.10, I have habitually included the SHOW STATISTICS statement in my considerations. The resulting metrics can aid in identifying statistical issues. Teradata Statistics – Avoid the Heuristics This case study demonstrates how the Optimizer …
When do you need a fire brigade most? When your house is on fire! When is the best time to establish the fire brigade? No, not when your house is on fire, but before the city the house is located in is founded. Finally, when should there be a fire safety inspection? Before and while you …
Learn about Teradata’s priority scheduler and how resources are allocated across workloads and requests in this detailed guide on workload management.
All-AMP and single-AMP operations are well-understood. All-AMP retrieval typically involves full table scans, including NUSI sub-table scans. On the other hand, single-AMP retrieval typically involves indexed access, such as UPI and NUPI. Group-AMP operations optimize requests by minimizing the number of active AMPs. These operations fall between single-AMP and all-AMP operations. The Optimizer employs group-AMP …
Introduction Teradata SQL lacks a built-in function to determine the ASCII code of a character. But fear not, for there exists a query workaround to this dilemma. This blog post will guide you through the process of using a straightforward SQL query in Teradata to find the ASCII code of a character. The solution is …
This course focuses on Teradata indexing techniques.
In this two-hour excursion, you will learn about Teradata’s architecture and Full Table Scans, different types of Primary Index Access such as UPI and NUPI, diverse Secondary Index Access including USI and NUSI, and Join Indexes.
You will gain the comprehensive knowledge required to create an ideal indexing landscape in your data warehouse setup.
As any experienced Teradata DBA will tell you, some tables in the Teradata dictionary (DBC) need housekeeping. But some customer sites that I have worked with ignore table DBC.AccessRights. If you have ever analyzed this table on a Teradata system, you will almost certainly spot two things quickly. Since this is a system table, altering …
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.