Surrogate Keys (Hash Keys)

Surrogate Keys (Hash Keys)

AnalyticsCreator can automatically generate surrogate keys for all tables:

1. Use the function Generate Hash Keys (Surrogate Keys)
2. AC creates a calculated field (e.g., SK_BSEG) for each table
3. Hash keys are based on the table’s primary key fields and stored as binary values to save space
4. These keys replace business keys in joins — improving performance and avoiding NULL joins