|
![]() |
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 |
Name | Connection Manager | Description |
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 |
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 |
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 |