Multiactive Satellite

Multiactive Satellite (aka multiactive_satellite)

This table is all about defining the multi-active satellites linked to a parent hub or link within your Data Vault. Here you configure the names of the multi-active 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 "multiactive_satellite" inside your metadata:

Name	Explanation
MA_Satellite_Identifier	A globally unique identifier of a multi-active 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.
Multi_Active_Attributes	The multi-active attribute or attributes of the satellite separated by a ;
Target_Column_Physical_Name	The physical name of the column in the satellite.
Target_Column_Sort_Order	The position of the column in the sort order for hashdiff generation.
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 multi-active satellite "customer_number_tpch_n_ma_s" from the parent hub "customer_h".

MA_Satellite_Identifier	Target_Satellite_Table_Physical_Name	Source_Table_Identifier	Source_Column_Physical_Name	Parent_Identifier	Parent_Primary_Key_Physical_Name	Multi_Active_Attributes	Target_Column_Physical_Name	Target_Column_Sort_Order	Group_Name
MAS0001	customer_number_tpch_n_ma_s	SRC0001	C_ACCTBAL	H001	hk_customer_h	C_NUMBER;C_FAX	C_ACCTBAL	1	Customer
MAS0001	customer_number_tpch_n_ma_s	SRC0001	C_COMMENT	H001	hk_customer_h	C_NUMBER;C_FAX	C_COMMENT	2	Customer
...	...	...	...	...	...	...	...	...	...
MAS0001	customer_number_tpch_n_ma_s	SRC0001	C_MKTSEGMENT	H001	hk_customer_h	C_NUMBER;C_FAX	C_MKTSEGMENT	17	Customer