TF_SCD DimPayee - Component

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>8216</LineageID><MappedToExistingDimensionLineageID>8130</MappedToExistingDimensionLineageID><Name>PayeeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8217</LineageID><MappedToExistingDimensionLineageID>8133</MappedToExistingDimensionLineageID><Name>PayeeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8218</LineageID><MappedToExistingDimensionLineageID>8136</MappedToExistingDimensionLineageID><Name>PayeeId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8219</LineageID><MappedToExistingDimensionLineageID>8139</MappedToExistingDimensionLineageID><Name>PayeeSequence</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8220</LineageID><MappedToExistingDimensionLineageID>8142</MappedToExistingDimensionLineageID><Name>PayeeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8221</LineageID><MappedToExistingDimensionLineageID>8145</MappedToExistingDimensionLineageID><Name>PayeeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8222</LineageID><MappedToExistingDimensionLineageID>8148</MappedToExistingDimensionLineageID><Name>PayeeName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8223</LineageID><MappedToExistingDimensionLineageID>8151</MappedToExistingDimensionLineageID><Name>IsMinority</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8224</LineageID><MappedToExistingDimensionLineageID>8154</MappedToExistingDimensionLineageID><Name>StateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8225</LineageID><MappedToExistingDimensionLineageID>8157</MappedToExistingDimensionLineageID><Name>State</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8226</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8227</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>Country</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8401</LineageID><MappedToExistingDimensionLineageID>8377</MappedToExistingDimensionLineageID><Name>PayeeNameConsolidated</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>8270</LineageID><MappedToExistingDimensionLineageID>8130</MappedToExistingDimensionLineageID><Name>PayeeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8271</LineageID><MappedToExistingDimensionLineageID>8133</MappedToExistingDimensionLineageID><Name>PayeeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8272</LineageID><MappedToExistingDimensionLineageID>8136</MappedToExistingDimensionLineageID><Name>PayeeId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8273</LineageID><MappedToExistingDimensionLineageID>8139</MappedToExistingDimensionLineageID><Name>PayeeSequence</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8274</LineageID><MappedToExistingDimensionLineageID>8142</MappedToExistingDimensionLineageID><Name>PayeeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8275</LineageID><MappedToExistingDimensionLineageID>8145</MappedToExistingDimensionLineageID><Name>PayeeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8276</LineageID><MappedToExistingDimensionLineageID>8148</MappedToExistingDimensionLineageID><Name>PayeeName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8277</LineageID><MappedToExistingDimensionLineageID>8151</MappedToExistingDimensionLineageID><Name>IsMinority</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8278</LineageID><MappedToExistingDimensionLineageID>8154</MappedToExistingDimensionLineageID><Name>StateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8279</LineageID><MappedToExistingDimensionLineageID>8157</MappedToExistingDimensionLineageID><Name>State</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8280</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8281</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>Country</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8411</LineageID><MappedToExistingDimensionLineageID>8377</MappedToExistingDimensionLineageID><Name>PayeeNameConsolidated</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 /><SpecialMembersColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PayeeSK</Name><LineageID>8130</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>PayeeAK</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8097</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PayeeAK</Name><LineageID>8133</LineageID><DataType>129</DataType><Length>14</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayeeId</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8100</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PayeeId</Name><LineageID>8136</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayeeSequence</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8103</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>PayeeSequence</Name><LineageID>8139</LineageID><DataType>2</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayeeTypeCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8106</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PayeeTypeCode</Name><LineageID>8142</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayeeType</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8109</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PayeeType</Name><LineageID>8145</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayeeName</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8112</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PayeeName</Name><LineageID>8148</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>IsMinority</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8115</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>IsMinority</Name><LineageID>8151</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StateCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8118</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>StateCode</Name><LineageID>8154</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>State</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8121</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>State</Name><LineageID>8157</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ZipCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8124</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ZipCode</Name><LineageID>8160</LineageID><DataType>129</DataType><Length>11</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Country</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8127</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>Country</Name><LineageID>8163</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayeeNameConsolidated</SourceSystemColumnName><SourceSystemLineageID>8374</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PayeeNameConsolidated</Name><LineageID>8377</LineageID><DataType>129</DataType><Length>50</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>8242</LineageID><MappedToExistingDimensionLineageID>8130</MappedToExistingDimensionLineageID><Name>PayeeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8243</LineageID><MappedToExistingDimensionLineageID>8133</MappedToExistingDimensionLineageID><Name>PayeeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8244</LineageID><MappedToExistingDimensionLineageID>8136</MappedToExistingDimensionLineageID><Name>PayeeId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8245</LineageID><MappedToExistingDimensionLineageID>8139</MappedToExistingDimensionLineageID><Name>PayeeSequence</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8246</LineageID><MappedToExistingDimensionLineageID>8142</MappedToExistingDimensionLineageID><Name>PayeeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8247</LineageID><MappedToExistingDimensionLineageID>8145</MappedToExistingDimensionLineageID><Name>PayeeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8248</LineageID><MappedToExistingDimensionLineageID>8148</MappedToExistingDimensionLineageID><Name>PayeeName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8249</LineageID><MappedToExistingDimensionLineageID>8151</MappedToExistingDimensionLineageID><Name>IsMinority</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8250</LineageID><MappedToExistingDimensionLineageID>8154</MappedToExistingDimensionLineageID><Name>StateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8251</LineageID><MappedToExistingDimensionLineageID>8157</MappedToExistingDimensionLineageID><Name>State</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8252</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8253</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>Country</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8405</LineageID><MappedToExistingDimensionLineageID>8377</MappedToExistingDimensionLineageID><Name>PayeeNameConsolidated</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>8202</LineageID><MappedToExistingDimensionLineageID>8130</MappedToExistingDimensionLineageID><Name>PayeeSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8203</LineageID><MappedToExistingDimensionLineageID>8133</MappedToExistingDimensionLineageID><Name>PayeeAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8204</LineageID><MappedToExistingDimensionLineageID>8136</MappedToExistingDimensionLineageID><Name>PayeeId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8205</LineageID><MappedToExistingDimensionLineageID>8139</MappedToExistingDimensionLineageID><Name>PayeeSequence</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8206</LineageID><MappedToExistingDimensionLineageID>8142</MappedToExistingDimensionLineageID><Name>PayeeTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8207</LineageID><MappedToExistingDimensionLineageID>8145</MappedToExistingDimensionLineageID><Name>PayeeType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8208</LineageID><MappedToExistingDimensionLineageID>8148</MappedToExistingDimensionLineageID><Name>PayeeName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8209</LineageID><MappedToExistingDimensionLineageID>8151</MappedToExistingDimensionLineageID><Name>IsMinority</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8210</LineageID><MappedToExistingDimensionLineageID>8154</MappedToExistingDimensionLineageID><Name>StateCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8211</LineageID><MappedToExistingDimensionLineageID>8157</MappedToExistingDimensionLineageID><Name>State</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8212</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>ZipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8213</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>Country</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8398</LineageID><MappedToExistingDimensionLineageID>8377</MappedToExistingDimensionLineageID><Name>PayeeNameConsolidated</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>8256</LineageID><MappedToExistingDimensionLineageID>8130</MappedToExistingDimensionLineageID><Name>PayeeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8257</LineageID><MappedToExistingDimensionLineageID>8133</MappedToExistingDimensionLineageID><Name>PayeeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8258</LineageID><MappedToExistingDimensionLineageID>8136</MappedToExistingDimensionLineageID><Name>PayeeId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8259</LineageID><MappedToExistingDimensionLineageID>8139</MappedToExistingDimensionLineageID><Name>PayeeSequence</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8260</LineageID><MappedToExistingDimensionLineageID>8142</MappedToExistingDimensionLineageID><Name>PayeeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8261</LineageID><MappedToExistingDimensionLineageID>8145</MappedToExistingDimensionLineageID><Name>PayeeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8262</LineageID><MappedToExistingDimensionLineageID>8148</MappedToExistingDimensionLineageID><Name>PayeeName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8263</LineageID><MappedToExistingDimensionLineageID>8151</MappedToExistingDimensionLineageID><Name>IsMinority</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8264</LineageID><MappedToExistingDimensionLineageID>8154</MappedToExistingDimensionLineageID><Name>StateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8265</LineageID><MappedToExistingDimensionLineageID>8157</MappedToExistingDimensionLineageID><Name>State</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8266</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8267</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>Country</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8408</LineageID><MappedToExistingDimensionLineageID>8377</MappedToExistingDimensionLineageID><Name>PayeeNameConsolidated</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>#8094</string><string>#8097</string><string>#8100</string><string>#8103</string><string>#8106</string><string>#8109</string><string>#8112</string><string>#8115</string><string>#8118</string><string>#8121</string><string>#8124</string><string>#8127</string><string>#8374</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>8190</LineageID><MappedToExistingDimensionLineageID>8130</MappedToExistingDimensionLineageID><Name>PayeeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8191</LineageID><MappedToExistingDimensionLineageID>8133</MappedToExistingDimensionLineageID><Name>PayeeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8192</LineageID><MappedToExistingDimensionLineageID>8136</MappedToExistingDimensionLineageID><Name>PayeeId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8193</LineageID><MappedToExistingDimensionLineageID>8139</MappedToExistingDimensionLineageID><Name>PayeeSequence</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8194</LineageID><MappedToExistingDimensionLineageID>8142</MappedToExistingDimensionLineageID><Name>PayeeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8195</LineageID><MappedToExistingDimensionLineageID>8145</MappedToExistingDimensionLineageID><Name>PayeeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8196</LineageID><MappedToExistingDimensionLineageID>8148</MappedToExistingDimensionLineageID><Name>PayeeName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8197</LineageID><MappedToExistingDimensionLineageID>8151</MappedToExistingDimensionLineageID><Name>IsMinority</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8198</LineageID><MappedToExistingDimensionLineageID>8154</MappedToExistingDimensionLineageID><Name>StateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8199</LineageID><MappedToExistingDimensionLineageID>8157</MappedToExistingDimensionLineageID><Name>State</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8200</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8201</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>Country</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8397</LineageID><MappedToExistingDimensionLineageID>8377</MappedToExistingDimensionLineageID><Name>PayeeNameConsolidated</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>8228</LineageID><MappedToExistingDimensionLineageID>8130</MappedToExistingDimensionLineageID><Name>PayeeSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8229</LineageID><MappedToExistingDimensionLineageID>8133</MappedToExistingDimensionLineageID><Name>PayeeAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8230</LineageID><MappedToExistingDimensionLineageID>8136</MappedToExistingDimensionLineageID><Name>PayeeId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8231</LineageID><MappedToExistingDimensionLineageID>8139</MappedToExistingDimensionLineageID><Name>PayeeSequence</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8232</LineageID><MappedToExistingDimensionLineageID>8142</MappedToExistingDimensionLineageID><Name>PayeeTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8233</LineageID><MappedToExistingDimensionLineageID>8145</MappedToExistingDimensionLineageID><Name>PayeeType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8234</LineageID><MappedToExistingDimensionLineageID>8148</MappedToExistingDimensionLineageID><Name>PayeeName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8235</LineageID><MappedToExistingDimensionLineageID>8151</MappedToExistingDimensionLineageID><Name>IsMinority</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8236</LineageID><MappedToExistingDimensionLineageID>8154</MappedToExistingDimensionLineageID><Name>StateCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8237</LineageID><MappedToExistingDimensionLineageID>8157</MappedToExistingDimensionLineageID><Name>State</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8238</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>ZipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8239</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>Country</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8402</LineageID><MappedToExistingDimensionLineageID>8377</MappedToExistingDimensionLineageID><Name>PayeeNameConsolidated</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

Property	Value
Name	TF_SCD DimPayee
Description
Up Stream Components	OLE_SRC Get DimPayee TF Case Transform
Down Stream Components	OLE_DST Load New Temp table for Payee OLE_DST Load SCD1 temp table for Payee
ID	7325
Component Class ID	{2E42D45B-F83C-400F-8D77-61DDE6A7DF29}
Contact Info
Identification String	component "TF_SCD DimPayee" (7325)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	False
Validate External Metadata	True
Version	11

Name	ID	LineageID
Country	8176	8163
IsMinority	8172	8151
PayeeAK	8166	8133
PayeeId	8167	8136
PayeeName	8171	8148
PayeeNameConsolidated	8395	8377
PayeeSequence	8168	8139
PayeeSK	8165	8130
PayeeType	8170	8145
PayeeTypeCode	8169	8142
RowEndDate	7542	6613
RowIsCurrent	7540	6607
RowStartDate	7541	6610
State	8174	8157
StateCode	8173	8154
ZipCode	8175	8160
Country	8187	8127
IsMinority	8183	8115
PayeeAK	8177	8097
PayeeId	8178	8100
PayeeName	8182	8112
PayeeNameConsolidated	8396	8374
PayeeSequence	8179	8103
PayeeType	8181	8109
PayeeTypeCode	8180	8106
State	8185	8121
StateCode	8184	8118
ZipCode	8186	8124

Name	ID	LineageID
Country	8213	8213
IsMinority	8209	8209
PayeeAK	8203	8203
PayeeId	8204	8204
PayeeName	8208	8208
PayeeNameConsolidated	8398	8398
PayeeSequence	8205	8205
PayeeSK	8202	8202
PayeeType	8207	8207
PayeeTypeCode	8206	8206
RowEndDate	7579	7579
RowIsCurrent	7577	7577
RowStartDate	7578	7578
State	8211	8211
StateCode	8210	8210
ZipCode	8212	8212
Country	8239	8239
IsMinority	8235	8235
PayeeAK	8229	8229
PayeeId	8230	8230
PayeeName	8234	8234
PayeeNameConsolidated	8402	8402
PayeeSequence	8231	8231
PayeeSK	8228	8228
PayeeType	8233	8233
PayeeTypeCode	8232	8232
RowEndDate	7607	7607
RowIsCurrent	7605	7605
RowStartDate	7606	7606
State	8237	8237
StateCode	8236	8236
ZipCode	8238	8238