Non Historized Satellite

Non-Historized Satellite (aka non_historized_satellite)

This table is all about defining the non-historized satellites linked to a parent hub or non-historized link within your Data Vault. Here you configure the names of the non-historized satellites, the names of the columns and where to find them within the source.

Columns

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

Name	Explanation
NH_Satellite_Identifier	A globally unique identifier of a non-historized satellite.
Target_Satellite_Table_Physical_Name	The name of this satellite object. Will be used for naming the generated satellite model.
Source_Table_Identifier	The global identifier of the source. Used to create a relation between satellite and source.
Source_Column_Physical_Name	The physical name of the column in the source data.
Parent_Identifier	The unique identifier of the parent hub or link entity this satellite is attached to. Defined in the metadata
Parent_Primary_Key_Physical_Name	The physical name of the primary key/hash key from the parent hub or link.
Target_Column_Physical_Name	The physical name of the column in the satellite.
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 Hub

See the following example values for each column. In total, they describe the non-historized satellite "orders_tpch_n_ns" from the parent hub "orders_h".

NH_Satellite_Identifier	Target_Satellite_Table_Physical_Name	Source_Table_Identifier	Source_Column_Physical_Name	Parent_Identifier	Parent_Primary_Key_Physical_Name	Target_Column_Physical_Name	Group_Name
NS0001	orders_tpch_n_ns	SRC0002	O_ORDERSTATUS	H0002	hk_orders_h	O_ORDERSTATUS	Orders
NS0001	orders_tpch_n_ns	SRC0002	O_TOTALPRICE	H0002	hk_orders_h	O_TOTALPRICE	Orders
...	...	...	...	...	...	...	...
NS0001	orders_tpch_n_ns	SRC0002	O_ORDERDATE	H0002	hk_orders_h	O_ORDERDATE	Orders

Example Link

See the following example values for each column. In total, they describe the non-historized satellite "orders_tpch_n_ns" from the parent link "orders_part_l".

NH_Satellite_Identifier	Target_Satellite_Table_Physical_Name	Source_Table_Identifier	Source_Column_Physical_Name	Parent_Identifier	Parent_Primary_Key_Physical_Name	Target_Column_Physical_Name	Group_Name
NS0002	orders_part_tpch_n_ns	SRC0002	O_ORDERSTATUS	L0001	hk_orders_part_l	O_ORDERSTATUS	Orders
NS0002	orders_part_tpch_n_ns	SRC0002	O_TOTALPRICE	L0001	hk_orders_part_l	O_TOTALPRICE	Orders
...	...	...	...	...	...	...	...
NS0002	orders_part_tpch_n_ns	SRC0002	O_ORDERDATE	L0001	hk_orders_part_l	O_ORDERDATE	Orders