Extend "Auditing" Columns Supported DataTypes and Values
description
The current release of the component permits specification of up to four auditing columns on the Existing Dimension input, one column for each "type" of auditing:
* A "row added" change
* A "last change of any type"
* An "SCD1 Change"
* An "SCD2 Change"
Each of those auditing columns was allowed to be associated with an SSIS integer-typed variable. When the component detected a row "change" that fit one of the above conditions, it populated the corresponding column with the value in the SSIS integer-typed variable.
We want to extend the current auditing system so that it is possible to identify more than one column on the Existing Dimension for each of the four types of Audit conditions. We also want to extend the system to permit non-integer type columns - specifically, we want to allow String types and Date types (at least).
Extending the system to allow more data types should not be particularly difficult - the most difficult part is anticipated to be comparing the SSIS variable type to the column type to ensure compatibility.
Extending the system to allow more than one column per auditing "condition" is more involved. Allowing more columns is easy - but a new framework in the editor has to be constructed to associate a variable with each column. In the past, it was simply a case of associating a variable with one of the auditing conditions - but this will no longer be sufficient, they have to be associated with a lineageID.