Q:Are Satellite Tables Required?

The latest question I received is:  do all the hubs and links will have satellites or only some of them?  In this post I will answer this question.  If you have a minute, please REGISTER FOR FREE for the blog (click BLOG->REGISTER), so that you can be updated with the latest release of information.  Also note: I answer questions like this frequently inside the coaching area.

Answer:

Satellite tables are NOT required for every Hub nor for every Link.  However, it is recommended that they be built.  Why? because Satellites provide context to answering your questions, they define the meaning of the keys, or the meaning of the relationship.

So, a Hub or a Link without any Satellites is “acceptable”, but it is undefined.  There is no meaning that can be attached to it (that is the statement you are making when you construct Hubs and Links without Satellites).

It is always better to add context IF YOU HAVE IT to produce a well-defined key.

Hope this helps,
Dan Linstedt
PS: on-line classes for implementation can be found at: http://LearnDataVault.com

Tags: , , ,

No comments yet.

Leave a Reply

*