What is a Hub?

Hubs are the core business entity that contain business key attributes.
It is generally defined with a field for the load timestamp (load date) and a field for where the data came from (record source).
Optionally it can be defined with a surrogate attribute by either an auto-incremented integer or a hash of the business key attributes.

How to create a Hub in 3D?

  1. Create an entity for the core business entity; for example, Customer.
  2. Add a business attribute CustomerName (can be more than one attribute).
  3. Set this attribute with the attribute type "Business key".
  4. Create a source set (or use an empty one) with a name associated to the source system (for documentation).
  5. Add the source entity to the source mapping set and choose the related source attribute for the created attributed (Only required to do the main source of the Hub).
    The source attribute is recommended to be the natural key, rather than a system key to support multiple source systems.

    Note

    Do not add sources for the Link into the Hub, it is more practical for RED's update procedure to handle this process.

  6. Repeat step 4 and 5 for additional source system.

Note

  • In principle, a Hub's business key should also be sourced by any source entities used in the Links.
  • The design in WhereScape 3D will not display this concept, but can be resolved during the processing in WhereScape RED.

Changes to be made in RED?

To add the source of the Link to the Hub...

  1. Add a new source mapping object on the Hub. 
  2. Add the Link's stage entity as a source with the relevant attribute sourcing to the Hub.|

Example

  • No labels