PIT
This node creates a PIT table to gather snapshot based information of one hub and its surrounding satellites. For this node to work, a snapshot table is required. The easiest way to create such a snapshot table is to use the 'Datavault by Scalefree: Snapshot v0' and 'Datavault by Scalefree: Snapshot v1' nodes provided by this package.
| Config Name | Config Type | Explanation | |||
|---|---|---|---|---|---|
| Dimension Key Column | columnSelector | The Dimension Key is the primary key of the PIT table. It is the hashed key, containing the business key of the Hub / Link and the snapshot date timestamp. First select these two columns in the 'Mapping' section and create a hashkey out of it. Rename it using your naming conventions, in this case to 'HK_{{name}}_D'. On the right side in the 'Config' section there is a tab 'Data Vault'. Expand it and bring the newly created column to the right side. | Clean Up PIT | Toggle | Default set to 'TRUE'. If enabled, on 'running' the PIT table will delete those records, where the 'SDTS' is not active. Therefore it would be necessary to use the logarithmic logic in the Snapshot_v1 node, as it wouldn't work without it. |
No Sys Columns are added inside a PIT Node.
Create the node:
- Create a node 'Datavault by Scalefree: PIT' by selecting both the hub, the surrounding satellites and the Snapshot_v1, right clicking the hub and then join these nodes together
- Create the Dimension Key as described above
- Select the unnecessary columns and delete them
- Rename the Hashkey of the satellite using your naming convention. In this case it's renamed to 'HK_CUSTOMER_N_S', as it is the Hashkey of the 'CUSTOMER_WIKI_N1_S'
- Rename the 'LDTS' the same way
- On the right side in the 'Config' section, inside the 'Data Vault' tab choose the Dimension Key in the column selector
- You may choose to disable 'Clean Up PIT'
- Create and run the node