DWHPro Insights

primary key

The Importance of Teradata Surrogate Keys Popular

Illustration of a dense isometric network of connected data nodes

What are Teradata Surrogate Keys? A surrogate key is an artificial identifier mapped to a natural key, often INTEGER or BIGINT. Generated identity values need not be gapless or globally increasing in insertion or retrieval order. We can use the ROW_NUMBER() function in Teradata to programmatically generate the surrogate key or an IDENTITY column for …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam