Utilities & Loading
A collection of 89 issues
Switching from Teradata to Snowflake: What to Know About DML Statements and Data Deletion
Understanding Teradata Load Isolation
Isolation Levels and their Impact on Performance & Concurrency
Isolation is a crucial factor in determining the visibility of transaction integrity to database users. This property guarantees that concurrently executed transactions produce identical results to those executed sequentially. Nonetheless, relinquishing this requirement can enhance transaction concurrency, improving performance. However, this
Teradata Transactions: Main Characteristics and Best Practices
Shrinking Teradata Tables: Reduce Table Size by 90% with This Simple Trick
Unlocking the Power of Teradata Macros: Features, Creation, and Execution
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