Ghost Record vs. Zero Key

 Zero Keys, in the Data Vault methodology, are exclusively used for NULL Business Keys. The following convention is the standard:

-1 for Business Key that is required

-2 for Business Key that is Optional 

 

Ghost Record, reside in the PIT and they make equi-joins work.