What are Teradata Surrogate Keys? A surrogate key in Teradata is used to map the natural keys of source systems to a unique key, usually an integer value. Usually, one or more natural key columns are mapped to a surrogate key worthy of an INTEGER. Often a consecutive number is generated. For a surrogate key

Read More

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 referencing table, which are a foreign key in the referenced table. Referential integrity is a robust mechanism to ensure data consistency in a database. What is Soft Referential Integrity? Soft Referential

Read More