dwhpro.com
Teradata - Posts - DWH Pro - The Teradata Experts
https://www.dwhpro.com/posts
Log into your account. Register for an account. A password will be e-mailed to you. Sign in / Join. Log into your account. Register for an account. A password will be e-mailed to you. A password will be e-mailed to you. DWH Pro – The Teradata Experts. Teradata Soft Referential Integrity. March 14, 2017. What is Referential Integrity? Referential integrity defines relationships between tables based on a primary key and a foreign key. It describes the columns in the. 8 Teradata Data Access Paths Explained.
dwhpro.com
Teradata - Teradata Secure Zones - Another great Post by David Wellman! - DWH Pro - The Teradata Experts
https://www.dwhpro.com/teradata-secure-zones
Log into your account. Register for an account. A password will be e-mailed to you. Sign in / Join. Log into your account. Register for an account. A password will be e-mailed to you. A password will be e-mailed to you. DWH Pro – The Teradata Experts. Teradata Secure Zones – Another great Post by David Wellman! Teradata Secure Zones – Another great Post by David Wellman! July 31, 2016. This article is aimed at providing some clear information for anyone considering the use of this feature. The difference...
dwhpro.com
Teradata - Teradata Numeric Functions - DWH Pro - The Teradata Experts
https://www.dwhpro.com/teradata-numeric-functions
Log into your account. Register for an account. A password will be e-mailed to you. Sign in / Join. Log into your account. Register for an account. A password will be e-mailed to you. A password will be e-mailed to you. DWH Pro – The Teradata Experts. December 31, 2016. Countless times I would have needed a function which allows me to check if a character column represents a numeric value. Usually, I used a workaround such as:. TRUNC will truncate a numeric value (such as decimal(n,m) :. Similar to CEILI...
dwhpro.com
Teradata - How Teradata sorts the Result Set - DWH Pro - The Teradata Experts
https://www.dwhpro.com/teradata-sorts-result-set
Log into your account. Register for an account. A password will be e-mailed to you. Sign in / Join. Log into your account. Register for an account. A password will be e-mailed to you. A password will be e-mailed to you. DWH Pro – The Teradata Experts. How Teradata sorts the Result Set. How Teradata sorts the Result Set. December 15, 2016. Teradata uses another sort approach. Here is how it works:. The whole process continues as long as the client fetches rows from the result set or no more rows are avail...
dwhpro.com
Teradata - Blog - DWH Pro - The Teradata Experts
https://www.dwhpro.com/category/teradata-downloads
Log into your account. Register for an account. A password will be e-mailed to you. Sign in / Join. Log into your account. Register for an account. A password will be e-mailed to you. A password will be e-mailed to you. DWH Pro – The Teradata Experts. Teradata Soft Referential Integrity. March 14, 2017. 8 Teradata Data Access Paths Explained. March 11, 2017. Data Modeling and the Teradata FSLDM. The 4 Principal Teradata Join Strategies. 3 Best Ways to detect Teradata Skewing. March 14, 2017. March 9, 2017.
dwhpro.com
General Archives - DWH Pro - The Teradata Experts
https://www.dwhpro.com/category/teradata
Log into your account. Register for an account. A password will be e-mailed to you. Sign in / Join. Log into your account. Register for an account. A password will be e-mailed to you. A password will be e-mailed to you. DWH Pro – The Teradata Experts. A Short Teradata Quiz for You. October 26, 2015. Engaging a Teradata Tuning Specialist is not a Luxury. September 9, 2015. 7 Essential General Teradata Tuning Tips. July 3, 2015. Let’s Solve Teradata Problems Together! June 10, 2015. January 15, 2015. In or...
dwhpro.com
Architecture Archives - DWH Pro - The Teradata Experts
https://www.dwhpro.com/category/teradata-architecture
Log into your account. Register for an account. A password will be e-mailed to you. Sign in / Join. Log into your account. Register for an account. A password will be e-mailed to you. A password will be e-mailed to you. DWH Pro – The Teradata Experts. Teradata Soft Referential Integrity. March 14, 2017. March 8, 2017. Data Modeling and the Teradata FSLDM. March 6, 2017. Teradata IPE – Incremental Planning and Execution. March 5, 2017. March 2, 2017. The Fundamentals of FastLoading on Teradata. In order t...
dwhpro.com
Teradata - Don't get fooled by the Statistic Estimations - DWH Pro - The Teradata Experts
https://www.dwhpro.com/dont-get-fooled-statistic-estimations
Log into your account. Register for an account. A password will be e-mailed to you. Sign in / Join. Log into your account. Register for an account. A password will be e-mailed to you. A password will be e-mailed to you. DWH Pro – The Teradata Experts. Don’t get fooled by the Statistic Estimations. Don’t get fooled by the Statistic Estimations. December 21, 2016. In different words: The Optimizer can easily determine the number of rows being retrieved by looking up the biases value in the histogram. We ca...
dwhpro.com
Teradata - Teradata Statistics Extrapolation for DATE Columns - DWH Pro - The Teradata Experts
https://www.dwhpro.com/teradata-statistics-extrapolation
Log into your account. Register for an account. A password will be e-mailed to you. Sign in / Join. Log into your account. Register for an account. A password will be e-mailed to you. A password will be e-mailed to you. DWH Pro – The Teradata Experts. Teradata Statistics Extrapolation for DATE Columns. Teradata Statistics Extrapolation for DATE Columns. April 20, 2015. What is Teradata Statistics Extrapolation? Here is a typical example:. SELECT Snapshot Date,Count(*) CNT FROM The Snapshot Table;. Extrap...
dwhpro.com
Stored Procedures Archives - DWH Pro - The Teradata Experts
https://www.dwhpro.com/category/teradata-stored-procedures
Log into your account. Register for an account. A password will be e-mailed to you. Sign in / Join. Log into your account. Register for an account. A password will be e-mailed to you. A password will be e-mailed to you. DWH Pro – The Teradata Experts. 10 Reasons for Organizing Stored Procedure into Chapters and Steps. March 29, 2015. Teradata Stored Procedures – Dynamic or Static SQL. January 28, 2015. Teradata Stored Procedures – Error Handling. January 27, 2015. October 25, 2014. September 28, 2014.