When reviewing the NULL business key section of CDVP2 training, the material says “Hash is computed Constant”. Does that mean it is just the normal hash of the zero key values of “-1” or “-2”? Or is it a hash constant (similar to ghost key hash) of “00000000000000000000000000000000” or “11111111111111111111111111111111”?
The training material indicates zero keys should be "pre-populated in all tables". In addition, DV2 book (and other trainers here in DVA through their posts) indicate ghost records should also be pre-populated in all tables. If zero key records are not the same as ghost records, does that mean I need to pre-load every table with three records total (example for hub below)?
00000000000000000000000000000000 <NA> <- Ghost record
<true hash of -1 or hash constant (see question1)> -1 <- Zero key record: required
<true hash of -2 or hash constant (see question1)> -2 <- Zero key record: optional