Standard Link

The "Datavault4Coalesce: Hub" node creates a link entity, connecting two or more entities, or an entity with itself.

User Configuration

Config Name	Config Type	Explanation
Link Hashkey Column	string	Name of the link hashkey column of the Link. Should got calculated out of all business keys inside the link.
Foreign Hashkeys	string	Name of the hashkey columns that refer to the other Link entities. All hashkey columns must be available inside the stage area. One oolumn per refered entitiy.
ldts	timestamp	Name of the ldts column inside the Link. The defined ldts of the stage will be used.
rsrc	string	Name of the rsrc column inside the Link. The defined rsrc of the stage will be used.

System Columns

No Sys Columns are added inside a Link Node.

Example 1

Description

In this example the Link 'NATION_REGION_L' is being created. The source table is 'STG_NATION'.

Create the node:

• Select the 'STG_NATION' and create the node 'NATION_REGION_L' with the node type 'Datavault by Scalefree: Link'
  
  

• The Links name will be created automatically. Rename the Link using your naming conventions. In this case rename it to 'NATION_REGION_L'. Also while having the Note open like in the Screenshot, delete all unnecessary columns, so that you only keep the Hashkey of the Link, the foreign hashkeys of the entities and the ldts aswell as the rsrc.

• Open the node and delete all unnecessary columns, so that you only keep the Hashkey of the Link, the foreign hashkeys of the entities and the ldts aswell as the rsrc.
  
  

• In the Config section on the right there is a tab called 'Data Vault'
• Expand this and you get a column selector list 'Hashkey Column' and 'LoadDateTimeStamp Column'
  • Select the hashkey of this Link and bring it to the right side in the 'Hashkey Column' section
  • Select the ldts of this Link and bring it to the right side in the 'LoalDateTimestamp Column' section
    
    

• link_hashkey:
  • :
• foreign_hashkeys:
• source_models: *

Example 2

Description

• link_hashkey:
  • :
• foreign_hashkeys:
• source_models: *
  *