Zero Key in Hub

Hi Patrick,

Thanks for your immense contribution to datavault world.

I have a quick question regarding zero records in satellites. Per your suggestion, we don’t need zero keys in the satellite. I didn’t find the reason for it. It would be great if you could elaborate more on that.

Thanks,
Sameer

Well… you don’t need Zero Keys pre-loaded anywhere… :wink:

So imagine where zero keys are assigned, in the coalesce of staging where null keys are detected.

From staging the business keys (of course) go to hub tables, the hashed result of those keys (+bkcc +tenantid) go to related link and satellite tables. You’ll find zero keys will naturally load to those target tables. No-preloading is necessary.

This means you will find zero-keys in hubs and links and optionally if the attributes for a business key in a relationship has had its attributes split into its own satellite table.

This promotes equi-join performance between these artefacts. A bit of an extension on this article I guess!