Key Generation

Key generation is performed for tables that have sequential or system generated prime key. This is performed automatically for Java instances via the OUAF enTegrity.

Tables with a system-generated key contain their own unique key that is replicated in a related 'key table' suffixed with '_K'. The purpose of the key table is to store the table identifier as well as the identifier of the environment in which the data row exists. An example is the Account table containing the Account identifier and the Account Key table containing the Account identifier and the Environment identifier.

These key tables support the Content Migration Assistant functionality by ensuring that a key will be unique across environments.