Skip to end of banner
Go to start of banner

ELT SCD2 Scenarios

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

In this article

This article emphasizes the different scenarios possible while performing an SCD2 operation and the behavior of the ELT SCD2 Snap in each of these scenarios.

To follow these scenarios and configure the ELT SCD2 Snap in your SnapLogic environment, you will need to understand the following terms:

Term

Definition

Target Table Natural Key

A unique identifier based on which the SCD2 operation inserts a new record with different values for the same

Scenario 1: Ideal SCD2 operation

  • No labels