Non Historized Link

Non-Historized Link (aka non_historized_link)

This table is all about defining the non-historized link entities within your Data Vault. Here you configure the names of the links, foreign keys (e.g. Hub Hashkeys) and detailed information about possible prejoins.

Columns

The following columns are required in the table/worksheet called "non_historized_link" inside your metadata:

Name	Explanation
NH_Link_Identifier	A globally unique identifier of this one link object.
Target_Link_Table_Physical_Name	The name of this link object. Will be used for naming the generated link model.
Source_Table_Identifier	The global identifier of the source. Used to create a relation between link and source.
Source_column_physical_name	The physical name of the column that holds the business key of the source.
Prejoin_Table_Identifier(optional)	The globally unique identifier of the source that is needed for the prejoin.
Prejoin_Table_Column_Name(optional)	The physical name of the business key inside the original source table, that refers to the source data.
Prejoin_Extraction_Column_Name(optional)	The physical name of the business key inside the prejoined table.
Prejoin_Target_Column_Alias(optional)	An optional column to give the prejoined business key an alias.
Hub_Identifier(optional)	The unique identifier of the parent hub entity this link is attached to. Defined in the metadata
Hub_primary_key_physical_name(optional)	The physical name of the primary key/hash key column of a referenced hub.
Target_column_physical_name	The physical name of the column in the target link table.
Target_Column_Sort_Order	The position of the business key in the sort order for the hashkey generation.
Target_Primary_Key_Physical_Name	The physical name of the primary key/hash key for the link 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.
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.

Example

See the following example values for each column. In total, they describe the non-historized link "creditcard_transactions_nl" between the hubs "accounts_pleo_h" and "employees_pleo_h" from the source system "Pleo".

NH_Link_Identifier	Target_link_table_physical_name	Source_Table_Identifier	Source_column_physical_name	Prejoin_Table_Identifier	Prejoin_Table_Column_Name	Prejoin_Extraction_Column_Name	Prejoin_Target_Column_Alias	Hub_Identifier	Hub_primary_key_physical_name	Target_column_physical_name	Target_Column_Sort_Order	Target_Primary_Key_Physical_Name	Record_Tracking_Satellite	Group_Name
NL0004	creditcard_transactions_nl	SRC0010	acc_id					H0007	hk_accounts_pleo_h	hk_accounts_pleo_h	1	hk_creditcard_transactions_nl	0	expenses
NL0004	creditcard_transactions_nl	SRC0010	emp_id					H0008	hk_employees_pleo_h	hk_employees_pleo_h	2	hk_creditcard_transactions_nl	0	expenses
NL0004	creditcard_transactions_nl	SRC0010	timestamp							timestamp	3	hk_creditcard_transactions_nl	0	expenses
NL0004	creditcard_transactions_nl	SRC0010	receipt_id							receipt_id			0	expenses