Output Column Selection Tab

Parent Previous Next


Output Column Selection Tab


In the Output Column Selection Tab, users can select which outputs to attach to the component and which columns will be included/excluded in the output.



The final step in configuring the Dimension Merge SCD is to attach all of the outputs configured in the Output Column Selection tab. Below is a list of all available outputs as well as a brief description:


 Auditing - The "Auditing" output processes Input/output counter information configured in the Auditing tab. Users who do not wish to include the "Auditing" output can dismiss the warning by selecting the "Auditing" output found on the Output tab, press the "Exclude All" button, and ensure that the "Don't warn that this output isn't attached" button is checked.

 Deleted - The "Deleted" output manages the records that are present and "active" within the Existing Dimension, but no longer appear within the Source System data stream. Records passed down the "Deleted" output can either be expired or deleted from the Existing Dimension. Expiration/deletion from the Existing Dimension are based on the Surrogate Key column(s). Users who desire their "Deleted" output to be expired may redirect their deleted rows to the "Expired SCD2 with SCD1 Changes" output. Additionally, users who do not wish to include the "Deleted" output can dismiss the warning by selecting the "Deleted" output found on the Output tab, press the "Exclude All" button, and ensure that the "Don't warn that this output isn't attached" button is checked.

 Expired SCD2 with SCD1 Changes - The "Expired SCD2 with SCD1 Changes" output expires current SCD2 records that are being updated in the existing dimension. Records passed down the "Expired SCD2 with SCD1 Changes" are expired from the Existing Dimension based on the Surrogate Key column(s). Users who do not wish to include the "Expired SCD2 with SCD1 Changes" output can dismiss the warning by selecting the "Expired SCD2 with SCD1 Changes" output found on the Output tab, press the "Exclude All" button, and ensure that the "Don't warn that this output isn't attached" button is checked.

 Invalid Input - The "Invalid Input" output handles any invalid rows that match the configured rules found on the Row Change Detection tab (such as NULL values in columns not configured as Nullable). Users who do not wish to include the "Invalid Input" output can dismiss the warning by selecting the "Invalid Input" output found on the Output tab, press the "Exclude All" button, and ensure that the "Don't warn that this output isn't attached" button is checked.

 New - The "New" output handles records that are not present within the Existing Dimension, but found within the Source System. Any record passed down the "New" output will require being inserted into the Existing Dimension. Users who do not wish to include the "New" output can dismiss the warning by selecting the "New" output found on the Output tab, press the "Exclude All" button, and ensure that the "Don't warn that this output isn't attached" button is checked.

 New SCD2 - The "New SCD2" output works along side the "Expired SCD2 with SCD1 Changes" output to insert a new record for historical records. Users who do not wish to have an additional output can redirect the "New SCD2" output to the "New" output. Users who do not wish to include the "New SCD2" output can dismiss the warning by selecting the "New SCD2" output found on the Output tab, press the "Exclude All" button, and ensure that the "Don't warn that this output isn't attached" button is checked.

 Statistics - The "Statistics" output processes statistical information for the current package execution such as the number of Source System Input records, Existing Dimension Input records, and Interval Start/End times. Users who do not wish to include the "Statistics" output can dismiss the warning by selecting the "Statistics" output found on the Output tab, press the "Exclude All" button, and ensure that the "Don't warn that this output isn't attached" button is checked.

 Unchanged - The "Unchanged" output is an optional output that will output all rows that have no changes between the Existing Dimension and the Source System data stream, or rows, that do not appear in the Source System data stream and are "expired" in the Existing Dimension. Users who do not wish to include the "Unchanged" output can dismiss the warning by selecting the "Unchanged" output found on the Output tab, press the "Exclude All" button, and ensure that the "Don't warn that this output isn't attached" button is checked.

 Updated SCD1 - The "Updated SCD1" output records that contain updated values to non-historical columns. Users who do not wish to include the "Updated SCD1" output can dismiss the warning by selecting the "Updated SCD1" output found on the Output tab, press the "Exclude All" button, and ensure that the "Don't warn that this output isn't attached" button is checked.


Once outputs are attached, re-open the Dimension Merge SCD Transform to dismiss warnings referencing unattached outputs. Keep in mind that warnings will remain for any output that has been configured in the Output Column Selection Tab that does not have the "Don't warn that this output isn't attached" button checked.