Teradata: Surrogate Key Concept

Teradata: Surrogate Key Concept

Surrogate Key is a unique, database supplied or generated identifier generally used as the primary key/index of a table.




➠ When to use a surrogate key



➠ Advantages of surrogate key



➠ Disadvantages of surrogate key



➠ How to generate surrogate key in Teradata