Skip to content

Home

Jump to bottom
Tim Kirschke edited this page Mar 16, 2023 · 21 revisions

Welcome to datavault4coalesce

The following documentation sheds some light on the node types that have been developed by Scalefree to make your Coalesce-Experience more comfortable! The documentation can be found by clicking the links in the sidebar on the right side. In the documentation, the macros and their parameters are explained and further exemplified.

Included node types

  • Staging Area
  • Hubs, Links & Satellites
  • PIT Tables
  • Snapshot Control

With datavault4coalesce you will get a lot of awesome features, including:

Features

  • Ghost Records
  • Multi Batch Processing
  • Automatic PIT cleanup based on logarithmic snapshot logic
  • Pattern based on years of experience in Data Vault Loading
  • Virtual Load Enddate

Requirements

To use the node types efficiently, there are a few prerequisites you need to provide:

  • Coalesce Environment connected to a Snowflake Instance
  • Basic Data Vault Knowledge (If this is new to you, check the following Article)

Installation

To have access to the Datavault4Coalesce node definitions, you have to write an email to [email protected] and request that the package is added to your environment!

Resources:

Table of Content

  1. Staging
  2. DV-Entities
    1. Hubs
    2. Links
      1. Standard Link
      2. Non-Historized Link
    3. Satellites
      1. Standard Satellite
        1. Standard Satellite v0
        2. Standard Satellite v1
      2. Multi-Active Satellite
        1. Multi-Active Satellite v0
        2. Multi-Active Satellite v1
      3. Non-Historized Satellite
      4. Record-Tracking Satellite
    4. Business Vault
      1. PIT
      2. Snapshot Control
        1. Snapshot Control v0
        2. Snapshot Control v1
  3. Global Variables
Clone this wiki locally