Learn how to optimize your Teradata Load Performance by choosing the right loading method per table. Bulk loads for large tables and transactional loads for small ones. Find out more in this article.
Introduction to Teradata Volatile Tables and Snowflake Temporary Tables Teradata and Snowflake offer temporary tables. This post will compare and contrast the types of tables available on each platform. We will examine table types found only in Teradata and Snowflake and show their ideal use cases.
Learn about the basics of Teradata architecture and why it’s still a top RDBMS for Data Warehousing. Discover how the system is built for parallelism and how hashing algorithms help distribute data evenly among AMPs. Explore the essential roles of Parsing Engines, AMPs, and Nodes in executing instructions and managing resources.
Learn how to efficiently add new partitions to a Row Partitioned Table. We compare two methods, ALTER TABLE and INSERT…SELECT, with test results.
Learn how to handle rounding issues in Teradata with this helpful article. Discover a possible solution to a common problem and improve your results!
Learn how to optimize Teradata SQL Tuning with comprehensive analysis of available tools in this article. Discover the optimal approach for query optimization for both tactical and strategic workloads, as well as methods for eliminating full table scans, reducing skew, and examining the execution plan. Plus, find out how to address common issues like concurrency and misestimation.
Learn about Teradata Spool Space, a temporary workspace used to store intermediate and final result sets. Discover ways to increase and manage Spool Space.
Learn the differences between Teradata SUBSTR and SUBSTRING functions for string manipulation. Discover the syntax variations, parameters, and usage examples.
Discover the differences between Teradata MULTISET and SET tables for effective data modeling. Learn how to avoid duplicates and improve performance.
Discover the power of Teradata FastLoad – the bulk load utility that efficiently loads vast amounts of data, bypassing the transient journal. Learn more here.
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.