Skip to content

Home

Jump to bottom
Deniz Polat edited this page Mar 1, 2023 · 21 revisions

Welcome to datavault4coalesce

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

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
  • Fix me! Wie kann man das Tool installieren?

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