Transformation's Source and Value Columns

In this topic we will explain the meaning of Source and Value (1 and 2) columns for each transformation. This column can be found in Transformation page used for defining all business rules.

Transformation Source Column Custom Value 1 Custom Value 2 
Business Key Input source column N/A N/A
SCD0 Input source column N/A N/A
SCD1 Input source column N/A N/A
SCD2 Input source column N/A N/A
SCD2 Date From N/A Value when new record Initial value
SCD2 Date To N/A Value when record “becoming old” (not active) Value when last record (active)
SCD2 Is Active N/A Value when active Value when not active
SCD3 Current Input source column N/A N/A
SCD3 Original Input source column N/A N/A
SCD3 Previous Input source column N/A N/A
SCD3 Date From N/A Effective from Initial value
Created Date N/A Value when created N/A
Modified Date N/A Value when modified Initial value
Deleted Date N/A Value when deleted Initial value
Is Deleted N/A Value when deleted Value when not deleted
Version Number N/A N/A N/A
Skip N/A N/A N/A

Last edited Jun 3, 2013 at 8:05 AM by knyazs, version 8

Comments

No comments yet.