-
Notifications
You must be signed in to change notification settings - Fork 6
Standard Hub
Hoa Le edited this page May 23, 2023
·
1 revision
This table is all about defining the hub entities within your Data Vault. Here you configure the names of the hubs, which business key they have and where to find them within the source as well as the hashing order.
The following columns are required in the table/worksheet called "hub_entities" inside your metadata:
| Name | Explanation |
|---|---|
| Hub_Identifier | A globally unique identifier of this one hub object. |
| Target_Hub_Table_Physical_Name | The name of this hub object. Will be used for naming the generated hub model. |
| Source_Table_Identifier | The global identifier of the source. Used to create a relation between hub and source. |
| Source_Column_Physical_Name | The physical name of the business key column in the source data. |
| Business_Key_Physical_Name | The physical name of the business key column in the hub. |
| Target_Column_Sort_Order | The position of the business key in the sort order for the hashkey generation. Influences the order of composite business keys. |
| Target_Primary_Key_Physical_Name | The physical name of the primary key/hash key for the hub object. |
| Record_Tracking_Satellite(optional) | A flag that indicates if a record tracking satellite should be generated. Inputs are 1 and 0 or empty. 1 if you want to create a record tracking satellite, 0 or empty if not. |
| Is_Primary_Source | A flag that indicates which source is set as the main resource, if the Hub is loaded from multiple sources. |
| Group_Name(optional) | Defines to which business object group this entry belongs, used for the folder structure of the dbt models as well as the visualization of the entities. |
See the following example values for each column. In total, they describe the hub "solution_h" from the source system "Salesforce_Solution" and the hub "part_h" from the source system "TPCH".
| Hub_Identifier | Target_Hub_Table_Physical_Name | Source_Table_Identifier | Source_Column_Physical_Name | Business_Key_Physical_Name | Target_Column_Sort_Order | Target_Primary_Key_Physical_Name | Record_Tracking_Satellite | Is_Primary_Source | Group_Name |
|---|---|---|---|---|---|---|---|---|---|
| H0001 | solution_h | SRC001 | SolutionNumber | SolutionNumber | 1 | hk_solution_h | 1 | 1 | Solution |
| H0002 | part_h | SRC002 | P_PARTKEY | P_PARTKEY | 1 | hk_part_h | 0 | 1 | Part |
Table of Content