DimPayableLoad
 TF_SCD DimPayable (Component)
  Properties
Property Value
Name TF_SCD DimPayable
Description
Up Stream Components
Down Stream Components
ID 7325
Component Class ID {2E42D45B-F83C-400F-8D77-61DDE6A7DF29}
Contact Info
Identification String component "TF_SCD DimPayable" (7325)
Is Default Locale True
Pipeline Version 0
Uses Dispositions False
Validate External Metadata True
Version 11
  Connections
Name Connection Manager Description
  Custom Properties
Name Value
(Obsolete) Route Deleted Rows to SCD2 Expired Output
False
(Obsolete) Route SCD2New Rows to New Output
False
Audit Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><CanIncludeSCDColumnTypes>Auditing</CanIncludeSCDColumnTypes><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7478</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7479</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7480</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7481</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7482</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7483</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7484</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7485</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7486</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7487</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7488</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7489</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7490</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7491</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7492</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7493</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7494</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7495</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7496</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7497</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7498</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7499</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Number of rows held in cache on first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7500</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7501</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7502</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7503</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7504</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7505</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7506</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7507</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum Output Rows per Second</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Debugging Messages
Deleted Output Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><LineageID>7592</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7593</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7594</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7598</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7962</LineageID><MappedToExistingDimensionLineageID>7862</MappedToExistingDimensionLineageID><Name>PayableSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7963</LineageID><MappedToExistingDimensionLineageID>7865</MappedToExistingDimensionLineageID><Name>PayableAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7964</LineageID><MappedToExistingDimensionLineageID>7868</MappedToExistingDimensionLineageID><Name>PayableNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7965</LineageID><MappedToExistingDimensionLineageID>7871</MappedToExistingDimensionLineageID><Name>OriginCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7966</LineageID><MappedToExistingDimensionLineageID>7874</MappedToExistingDimensionLineageID><Name>Origin</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7967</LineageID><MappedToExistingDimensionLineageID>7877</MappedToExistingDimensionLineageID><Name>ReferenceTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7968</LineageID><MappedToExistingDimensionLineageID>7880</MappedToExistingDimensionLineageID><Name>ReferenceType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7969</LineageID><MappedToExistingDimensionLineageID>7883</MappedToExistingDimensionLineageID><Name>PaymentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7970</LineageID><MappedToExistingDimensionLineageID>7886</MappedToExistingDimensionLineageID><Name>PaymentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7971</LineageID><MappedToExistingDimensionLineageID>7889</MappedToExistingDimensionLineageID><Name>PayableStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7972</LineageID><MappedToExistingDimensionLineageID>7892</MappedToExistingDimensionLineageID><Name>PayableStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7973</LineageID><MappedToExistingDimensionLineageID>7895</MappedToExistingDimensionLineageID><Name>PayableDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7974</LineageID><MappedToExistingDimensionLineageID>7898</MappedToExistingDimensionLineageID><Name>PaymentDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7975</LineageID><MappedToExistingDimensionLineageID>7901</MappedToExistingDimensionLineageID><Name>PaymentXrefNbr</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8164</LineageID><MappedToExistingDimensionLineageID>8147</MappedToExistingDimensionLineageID><Name>ReferenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8165</LineageID><MappedToExistingDimensionLineageID>8150</MappedToExistingDimensionLineageID><Name>PaymentTypeNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Deleted Output Counter
Error Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>1</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7476</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7477</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7644</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7645</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7646</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7650</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8024</LineageID><MappedToExistingDimensionLineageID>7862</MappedToExistingDimensionLineageID><Name>PayableSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8025</LineageID><MappedToExistingDimensionLineageID>7865</MappedToExistingDimensionLineageID><Name>PayableAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8026</LineageID><MappedToExistingDimensionLineageID>7868</MappedToExistingDimensionLineageID><Name>PayableNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8027</LineageID><MappedToExistingDimensionLineageID>7871</MappedToExistingDimensionLineageID><Name>OriginCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8028</LineageID><MappedToExistingDimensionLineageID>7874</MappedToExistingDimensionLineageID><Name>Origin</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8029</LineageID><MappedToExistingDimensionLineageID>7877</MappedToExistingDimensionLineageID><Name>ReferenceTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8030</LineageID><MappedToExistingDimensionLineageID>7880</MappedToExistingDimensionLineageID><Name>ReferenceType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8031</LineageID><MappedToExistingDimensionLineageID>7883</MappedToExistingDimensionLineageID><Name>PaymentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8032</LineageID><MappedToExistingDimensionLineageID>7886</MappedToExistingDimensionLineageID><Name>PaymentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8033</LineageID><MappedToExistingDimensionLineageID>7889</MappedToExistingDimensionLineageID><Name>PayableStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8034</LineageID><MappedToExistingDimensionLineageID>7892</MappedToExistingDimensionLineageID><Name>PayableStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8035</LineageID><MappedToExistingDimensionLineageID>7895</MappedToExistingDimensionLineageID><Name>PayableDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8036</LineageID><MappedToExistingDimensionLineageID>7898</MappedToExistingDimensionLineageID><Name>PaymentDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8037</LineageID><MappedToExistingDimensionLineageID>7901</MappedToExistingDimensionLineageID><Name>PaymentXrefNbr</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8178</LineageID><MappedToExistingDimensionLineageID>8147</MappedToExistingDimensionLineageID><Name>ReferenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8179</LineageID><MappedToExistingDimensionLineageID>8150</MappedToExistingDimensionLineageID><Name>PaymentTypeNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Existing Dimension Columns
<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SCDColumnType>7</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowIsCurrent</Name><LineageID>6607</LineageID><DataType>129</DataType><Length>1</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>6610</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>6613</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FiscalYear</SourceSystemColumnName><SourceSystemLineageID>7279</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FiscalYear</Name><LineageID>7303</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PayableSK</Name><LineageID>7862</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>PayableAK</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7823</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PayableAK</Name><LineageID>7865</LineageID><DataType>129</DataType><Length>12</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayableNumber</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7826</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PayableNumber</Name><LineageID>7868</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>OriginCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7829</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>OriginCode</Name><LineageID>7871</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Origin</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7832</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>Origin</Name><LineageID>7874</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReferenceTypeCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7835</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ReferenceTypeCode</Name><LineageID>7877</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReferenceType</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7838</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>ReferenceType</Name><LineageID>7880</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PaymentTypeCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7841</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PaymentTypeCode</Name><LineageID>7883</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PaymentType</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7844</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PaymentType</Name><LineageID>7886</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayableStatusCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7847</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PayableStatusCode</Name><LineageID>7889</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayableStatus</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7850</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PayableStatus</Name><LineageID>7892</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayableDate</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7853</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>PayableDate</Name><LineageID>7895</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PaymentDate</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7856</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>PaymentDate</Name><LineageID>7898</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PaymentXrefNbr</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7859</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PaymentXrefNbr</Name><LineageID>7901</LineageID><DataType>129</DataType><Length>12</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReferenceNumber</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8130</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ReferenceNumber</Name><LineageID>8147</LineageID><DataType>129</DataType><Length>20</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PaymentTypeNumber</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8133</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PaymentTypeNumber</Name><LineageID>8150</LineageID><DataType>129</DataType><Length>15</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition></ArrayOfInputColumnDefinition>
Existing Dimension Input Counter
Expired SCD2 Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7474</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7618</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7619</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7620</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7624</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7992</LineageID><MappedToExistingDimensionLineageID>7862</MappedToExistingDimensionLineageID><Name>PayableSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7993</LineageID><MappedToExistingDimensionLineageID>7865</MappedToExistingDimensionLineageID><Name>PayableAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7994</LineageID><MappedToExistingDimensionLineageID>7868</MappedToExistingDimensionLineageID><Name>PayableNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7995</LineageID><MappedToExistingDimensionLineageID>7871</MappedToExistingDimensionLineageID><Name>OriginCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7996</LineageID><MappedToExistingDimensionLineageID>7874</MappedToExistingDimensionLineageID><Name>Origin</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7997</LineageID><MappedToExistingDimensionLineageID>7877</MappedToExistingDimensionLineageID><Name>ReferenceTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7998</LineageID><MappedToExistingDimensionLineageID>7880</MappedToExistingDimensionLineageID><Name>ReferenceType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7999</LineageID><MappedToExistingDimensionLineageID>7883</MappedToExistingDimensionLineageID><Name>PaymentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8000</LineageID><MappedToExistingDimensionLineageID>7886</MappedToExistingDimensionLineageID><Name>PaymentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8001</LineageID><MappedToExistingDimensionLineageID>7889</MappedToExistingDimensionLineageID><Name>PayableStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8002</LineageID><MappedToExistingDimensionLineageID>7892</MappedToExistingDimensionLineageID><Name>PayableStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8003</LineageID><MappedToExistingDimensionLineageID>7895</MappedToExistingDimensionLineageID><Name>PayableDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8004</LineageID><MappedToExistingDimensionLineageID>7898</MappedToExistingDimensionLineageID><Name>PaymentDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8005</LineageID><MappedToExistingDimensionLineageID>7901</MappedToExistingDimensionLineageID><Name>PaymentXrefNbr</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8170</LineageID><MappedToExistingDimensionLineageID>8147</MappedToExistingDimensionLineageID><Name>ReferenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8171</LineageID><MappedToExistingDimensionLineageID>8150</MappedToExistingDimensionLineageID><Name>PaymentTypeNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Expired SCD2 Output Counter
Hashing Algorithm
0
Inferred Member False Value for Integer
1
Inferred Member False Value for Strings
N
Inferred Member True Value for Integer
0
Inferred Member True Value for Strings
Y
Invalid Input Output Counter
Last Window Size
0,0
Manage Surrogate Keys
False
New Output Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7472</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7577</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7578</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7579</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7583</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7946</LineageID><MappedToExistingDimensionLineageID>7862</MappedToExistingDimensionLineageID><Name>PayableSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7947</LineageID><MappedToExistingDimensionLineageID>7865</MappedToExistingDimensionLineageID><Name>PayableAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7948</LineageID><MappedToExistingDimensionLineageID>7868</MappedToExistingDimensionLineageID><Name>PayableNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7949</LineageID><MappedToExistingDimensionLineageID>7871</MappedToExistingDimensionLineageID><Name>OriginCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7950</LineageID><MappedToExistingDimensionLineageID>7874</MappedToExistingDimensionLineageID><Name>Origin</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7951</LineageID><MappedToExistingDimensionLineageID>7877</MappedToExistingDimensionLineageID><Name>ReferenceTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7952</LineageID><MappedToExistingDimensionLineageID>7880</MappedToExistingDimensionLineageID><Name>ReferenceType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7953</LineageID><MappedToExistingDimensionLineageID>7883</MappedToExistingDimensionLineageID><Name>PaymentTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7954</LineageID><MappedToExistingDimensionLineageID>7886</MappedToExistingDimensionLineageID><Name>PaymentType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7955</LineageID><MappedToExistingDimensionLineageID>7889</MappedToExistingDimensionLineageID><Name>PayableStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7956</LineageID><MappedToExistingDimensionLineageID>7892</MappedToExistingDimensionLineageID><Name>PayableStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7957</LineageID><MappedToExistingDimensionLineageID>7895</MappedToExistingDimensionLineageID><Name>PayableDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7958</LineageID><MappedToExistingDimensionLineageID>7898</MappedToExistingDimensionLineageID><Name>PaymentDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7959</LineageID><MappedToExistingDimensionLineageID>7901</MappedToExistingDimensionLineageID><Name>PaymentXrefNbr</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8160</LineageID><MappedToExistingDimensionLineageID>8147</MappedToExistingDimensionLineageID><Name>ReferenceNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8161</LineageID><MappedToExistingDimensionLineageID>8150</MappedToExistingDimensionLineageID><Name>PaymentTypeNumber</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
New Output Counter
New SCD2 Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7475</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7631</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7632</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7633</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7637</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8008</LineageID><MappedToExistingDimensionLineageID>7862</MappedToExistingDimensionLineageID><Name>PayableSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8009</LineageID><MappedToExistingDimensionLineageID>7865</MappedToExistingDimensionLineageID><Name>PayableAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8010</LineageID><MappedToExistingDimensionLineageID>7868</MappedToExistingDimensionLineageID><Name>PayableNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8011</LineageID><MappedToExistingDimensionLineageID>7871</MappedToExistingDimensionLineageID><Name>OriginCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8012</LineageID><MappedToExistingDimensionLineageID>7874</MappedToExistingDimensionLineageID><Name>Origin</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8013</LineageID><MappedToExistingDimensionLineageID>7877</MappedToExistingDimensionLineageID><Name>ReferenceTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8014</LineageID><MappedToExistingDimensionLineageID>7880</MappedToExistingDimensionLineageID><Name>ReferenceType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8015</LineageID><MappedToExistingDimensionLineageID>7883</MappedToExistingDimensionLineageID><Name>PaymentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8016</LineageID><MappedToExistingDimensionLineageID>7886</MappedToExistingDimensionLineageID><Name>PaymentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8017</LineageID><MappedToExistingDimensionLineageID>7889</MappedToExistingDimensionLineageID><Name>PayableStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8018</LineageID><MappedToExistingDimensionLineageID>7892</MappedToExistingDimensionLineageID><Name>PayableStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8019</LineageID><MappedToExistingDimensionLineageID>7895</MappedToExistingDimensionLineageID><Name>PayableDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8020</LineageID><MappedToExistingDimensionLineageID>7898</MappedToExistingDimensionLineageID><Name>PaymentDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8021</LineageID><MappedToExistingDimensionLineageID>7901</MappedToExistingDimensionLineageID><Name>PaymentXrefNbr</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8174</LineageID><MappedToExistingDimensionLineageID>8147</MappedToExistingDimensionLineageID><Name>ReferenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8175</LineageID><MappedToExistingDimensionLineageID>8150</MappedToExistingDimensionLineageID><Name>PaymentTypeNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
New SCD2 Output Counter
Number of Processing Threads
0
Processing Timeout
3600
SCD2 Current Member False Value for Integer
1
SCD2 Current Member False Value for Strings
N
SCD2 Current Member True Value for Integer
0
SCD2 Current Member True Value for Strings
Y
SCD2 Date Millisecond Precision
3
SCD2 Desired Expiry For Current Records
0
SCD2 Expiry Date Variable
SCD2 Gap Granularity
2
SCD2 Gap Offset
1
SCD2 Now Variable
System::ContainerStartTime
SCD2 Specific Expiry Date
<?xml version="1.0" encoding="utf-16"?><ArrayOfLong />
Source System Input Counter
Source System Lineages
<?xml version="1.0" encoding="utf-16"?><ArrayOfString><string>#6511</string><string>#6514</string><string>#7279</string><string>#7820</string><string>#7823</string><string>#7826</string><string>#7829</string><string>#7832</string><string>#7835</string><string>#7838</string><string>#7841</string><string>#7844</string><string>#7847</string><string>#7850</string><string>#7853</string><string>#7856</string><string>#7859</string><string>#8130</string><string>#8133</string></ArrayOfString>
Special Members Input Counter
Special Members Lineages
<?xml version="1.0" encoding="utf-16"?><ArrayOfString />
Statistics Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><CanIncludeSCDColumnTypes>None</CanIncludeSCDColumnTypes><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7508</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7509</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7510</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7511</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7512</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7513</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7514</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7515</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7516</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7517</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7518</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7519</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7520</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7521</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7522</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7523</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7524</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7525</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7526</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7527</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7528</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7529</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7530</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7531</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7532</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7533</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7534</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Input Waiting On Row Processing</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Suppress Warnings About Optimizing Performance Through Sorted Inputs
False
Suppress Warnings About Optimizing Performance Through Surrogate Key Configuration
False
Suppress Warnings About Surrogate Key Configuration
False
Surrogate Key Increment
1
Surrogate Key Increment By Variable?
False
Surrogate Key Increment Variable
Surrogate Key Seed
0
Surrogate Key Seed By Variable?
False
Surrogate Key Seed Variable
Surrogate Key Seed Variable Guaranteed
False
Unchanged Output Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ArrayOfOutputColumnDefinition><OutputColumnDefinition><LineageID>7564</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7565</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7566</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7570</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7932</LineageID><MappedToExistingDimensionLineageID>7862</MappedToExistingDimensionLineageID><Name>PayableSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7933</LineageID><MappedToExistingDimensionLineageID>7865</MappedToExistingDimensionLineageID><Name>PayableAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7934</LineageID><MappedToExistingDimensionLineageID>7868</MappedToExistingDimensionLineageID><Name>PayableNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7935</LineageID><MappedToExistingDimensionLineageID>7871</MappedToExistingDimensionLineageID><Name>OriginCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7936</LineageID><MappedToExistingDimensionLineageID>7874</MappedToExistingDimensionLineageID><Name>Origin</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7937</LineageID><MappedToExistingDimensionLineageID>7877</MappedToExistingDimensionLineageID><Name>ReferenceTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7938</LineageID><MappedToExistingDimensionLineageID>7880</MappedToExistingDimensionLineageID><Name>ReferenceType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7939</LineageID><MappedToExistingDimensionLineageID>7883</MappedToExistingDimensionLineageID><Name>PaymentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7940</LineageID><MappedToExistingDimensionLineageID>7886</MappedToExistingDimensionLineageID><Name>PaymentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7941</LineageID><MappedToExistingDimensionLineageID>7889</MappedToExistingDimensionLineageID><Name>PayableStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7942</LineageID><MappedToExistingDimensionLineageID>7892</MappedToExistingDimensionLineageID><Name>PayableStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7943</LineageID><MappedToExistingDimensionLineageID>7895</MappedToExistingDimensionLineageID><Name>PayableDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7944</LineageID><MappedToExistingDimensionLineageID>7898</MappedToExistingDimensionLineageID><Name>PaymentDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7945</LineageID><MappedToExistingDimensionLineageID>7901</MappedToExistingDimensionLineageID><Name>PaymentXrefNbr</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8158</LineageID><MappedToExistingDimensionLineageID>8147</MappedToExistingDimensionLineageID><Name>ReferenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8159</LineageID><MappedToExistingDimensionLineageID>8150</MappedToExistingDimensionLineageID><Name>PaymentTypeNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Unchanged Output Counter
Update SCD1 Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7473</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7605</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7606</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7607</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7611</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7976</LineageID><MappedToExistingDimensionLineageID>7862</MappedToExistingDimensionLineageID><Name>PayableSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7977</LineageID><MappedToExistingDimensionLineageID>7865</MappedToExistingDimensionLineageID><Name>PayableAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7978</LineageID><MappedToExistingDimensionLineageID>7868</MappedToExistingDimensionLineageID><Name>PayableNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7979</LineageID><MappedToExistingDimensionLineageID>7871</MappedToExistingDimensionLineageID><Name>OriginCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7980</LineageID><MappedToExistingDimensionLineageID>7874</MappedToExistingDimensionLineageID><Name>Origin</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7981</LineageID><MappedToExistingDimensionLineageID>7877</MappedToExistingDimensionLineageID><Name>ReferenceTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7982</LineageID><MappedToExistingDimensionLineageID>7880</MappedToExistingDimensionLineageID><Name>ReferenceType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7983</LineageID><MappedToExistingDimensionLineageID>7883</MappedToExistingDimensionLineageID><Name>PaymentTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7984</LineageID><MappedToExistingDimensionLineageID>7886</MappedToExistingDimensionLineageID><Name>PaymentType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7985</LineageID><MappedToExistingDimensionLineageID>7889</MappedToExistingDimensionLineageID><Name>PayableStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7986</LineageID><MappedToExistingDimensionLineageID>7892</MappedToExistingDimensionLineageID><Name>PayableStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7987</LineageID><MappedToExistingDimensionLineageID>7895</MappedToExistingDimensionLineageID><Name>PayableDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7988</LineageID><MappedToExistingDimensionLineageID>7898</MappedToExistingDimensionLineageID><Name>PaymentDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7989</LineageID><MappedToExistingDimensionLineageID>7901</MappedToExistingDimensionLineageID><Name>PaymentXrefNbr</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8166</LineageID><MappedToExistingDimensionLineageID>8147</MappedToExistingDimensionLineageID><Name>ReferenceNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8167</LineageID><MappedToExistingDimensionLineageID>8150</MappedToExistingDimensionLineageID><Name>PaymentTypeNumber</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Updated SCD1 Output Counter
UserComponentTypeName
PW.TaskFactory.DimensionMerge.DimensionMergeSCD, PW.TaskFactory.DimensionMergeSCD100, Version=1.0.0.0, Culture=neutral, PublicKeyToken=47acf905d0337c39
  Input Columns
Name ID LineageID
FiscalYear
7546
7303
Origin
7907
7874
OriginCode
7906
7871
PayableAK
7904
7865
PayableDate
7914
7895
PayableNumber
7905
7868
PayableSK
7903
7862
PayableStatus
7913
7892
PayableStatusCode
7912
7889
PaymentDate
7915
7898
PaymentType
7911
7886
PaymentTypeCode
7910
7883
PaymentTypeNumber
8153
8150
PaymentXrefNbr
7916
7901
ReferenceNumber
8152
8147
ReferenceType
7909
7880
ReferenceTypeCode
7908
7877
RowEndDate
7542
6613
RowIsCurrent
7540
6607
RowStartDate
7541
6610
FiscalYear
7555
7279
Origin
7920
7832
OriginCode
7919
7829
PayableAK
7917
7823
PayableDate
7927
7853
PayableNumber
7918
7826
PayableStatus
7926
7850
PayableStatusCode
7925
7847
PaymentDate
7928
7856
PaymentType
7924
7844
PaymentTypeCode
7923
7841
PaymentTypeNumber
8155
8133
PaymentXrefNbr
7929
7859
ReferenceNumber
8154
8130
ReferenceType
7922
7838
ReferenceTypeCode
7921
7835
  Output Columns
Name ID LineageID
FiscalYear
7583
7583
Origin
7950
7950
OriginCode
7949
7949
PayableAK
7947
7947
PayableDate
7957
7957
PayableNumber
7948
7948
PayableSK
7946
7946
PayableStatus
7956
7956
PayableStatusCode
7955
7955
PaymentDate
7958
7958
PaymentType
7954
7954
PaymentTypeCode
7953
7953
PaymentTypeNumber
8161
8161
PaymentXrefNbr
7959
7959
ReferenceNumber
8160
8160
ReferenceType
7952
7952
ReferenceTypeCode
7951
7951
RowEndDate
7579
7579
RowIsCurrent
7577
7577
RowStartDate
7578
7578
FiscalYear
7611
7611
Origin
7980
7980
OriginCode
7979
7979
PayableAK
7977
7977
PayableDate
7987
7987
PayableNumber
7978
7978
PayableSK
7976
7976
PayableStatus
7986
7986
PayableStatusCode
7985
7985
PaymentDate
7988
7988
PaymentType
7984
7984
PaymentTypeCode
7983
7983
PaymentTypeNumber
8167
8167
PaymentXrefNbr
7989
7989
ReferenceNumber
8166
8166
ReferenceType
7982
7982
ReferenceTypeCode
7981
7981
RowEndDate
7607
7607
RowIsCurrent
7605
7605
RowStartDate
7606
7606
Powered by BI Documenter