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.

Found an issue in documentation? Write to us.

 
Pricefx version 13.1