Teradata
A collection of 307 issues
Unlocking the Power of Teradata Macros: Features, Creation, and Execution
Teradata Sample Statistics: When, How, and Why to Use Them
Teradata Referential Integrity: What it is and Why You Need it for Data Consistency and Performance
Maximizing Performance with Multiple Teradata Sessions
7 Deadly Sins That Destroy A Teradata Data Warehouse
To exemplify the impact of mistakes in Teradata Data Warehouse projects, consider the analogy of a medical team. Imagine yourself as the project, preparing for a crucial and costly procedure. Naturally, you wouldn't want to hear the staff engage in the following conversations before administering the anesthesia.
1.
Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations
Teradata Table Design Checklist
As creating tables is a frequent task, I deemed it necessary to provide a checklist.
* Primary Index or NOPI?
* Is the Primary Index distributing rows evenly?
* Is the correct character set used?
* Are character sets and data types matching across tables?
* Can the Primary Index be
Teradata Query Parallelism: A closer look at how Teradata's shared-nothing architecture and parallel processing capabilities deliver exceptional performance.
Teradata Query Parallelism
A query on a Teradata system runs in parallel at every step, whether for joining, sorting, or aggregating data.
Teradata's uniqueness lies in its ability to apply parallelism at every step of the query process. This advantage resulted from its architectural design, which integrated high
The Importance of Teradata Surrogate Keys
Two Methods for Generating Number Ranges in Teradata
Method 1, avoiding any helper tables or functions which are only available in new releases of Teradata:
WITH RECURSIVE NumberRanges(TheNumber,TheString) AS
(
SELECT 1 AS TheNumber,casT(1 as VARCHAR(500)) as TheString
FROM
(
SELECT * FROM (SELECT NULL AS X) X
) DUMMYTABLE
UNION ALL
SELECT
TheNumber + 1 AS TheNumber,