QAD Data Warehouse Designer will by default always insert a record into the dimension with an artificial key value of zero. This record is used to link any fact records that do not have valid dimension joins. The values of the various columns in this record are acquired from the contents of the field 'Zero key value' which is set in the properties screen of each dimension column.