The Importance of Teradata Surrogate Keys Popular
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 …
