Zero key value
The field contains the data that will be placed in the zero key row in the dimension. All dimensions that use standard QAD Data Warehouse Designer generated procedures have a row with an artificial key of zero. This row is used to link to the fact records when no match on the dimension can be found. For example we may have some sales records that come through without a product defined. QAD Data Warehouse Designer will be default associate these fact records with the zero key product dimension entry. So, we might set the zero key value to 'Unknown product' for the name column in the product dimension.