Business Keys - Recommendations

Business key (also called "primary key") is a column which uniquely identifies each row in the data. For example, it can be a customer number in a CSM system or SKU number for a product. The business key value can come from a single column or can be composed of several columns (to achieve uniqueness).

General requirements for a business key:

• It is unique.

• It is always present in the data (i.e., no null values).

• It does not change in time.

Pricefx recommendations for business keys:

• Do not use values with national special characters. For details see Encoding. Also avoid using other uncommon special characters like %$" etc.

• Do not use values with leading (or trailing) spaces or other whitespace characters like tabs.