|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | TF Dimension Merge Slowly Changing Dimension Term |
| Description | |
| Up Stream Components | |
| Down Stream Components | |
| ID | 543 |
| Component Class ID | {2E42D45B-F83C-400F-8D77-61DDE6A7DF29} |
| Contact Info | |
| Identification String | component "TF Dimension Merge Slowly Changing Dimension Term" (543) |
| Is Default Locale | True |
| Pipeline Version | 0 |
| Uses Dispositions | False |
| Validate External Metadata | True |
| Version | 11 |
Connections
| Name | Connection Manager | Description |
Custom Properties
| Name | Value |
(Obsolete) Route Deleted Rows to SCD2 Expired Output |
False |
(Obsolete) Route SCD2New Rows to New Output |
False |
Audit Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><CanIncludeSCDColumnTypes>Auditing</CanIncludeSCDColumnTypes><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>631</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>632</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>633</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>634</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>635</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>636</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>637</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>638</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>639</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>640</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>641</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>642</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>643</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>644</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>645</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>646</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>647</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>648</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>649</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>650</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>651</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>652</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Number of rows held in cache on first key match</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>653</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>654</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>655</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>656</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>657</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>658</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>659</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>660</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum Output Rows per Second</Name></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>1168</LineageID><MappedToExistingDimensionLineageID>1012</MappedToExistingDimensionLineageID><Name>TermSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1169</LineageID><MappedToExistingDimensionLineageID>1015</MappedToExistingDimensionLineageID><Name>TermAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1170</LineageID><MappedToExistingDimensionLineageID>1018</MappedToExistingDimensionLineageID><Name>TermStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1171</LineageID><MappedToExistingDimensionLineageID>1021</MappedToExistingDimensionLineageID><Name>TermEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1172</LineageID><MappedToExistingDimensionLineageID>1024</MappedToExistingDimensionLineageID><Name>TermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1173</LineageID><MappedToExistingDimensionLineageID>1027</MappedToExistingDimensionLineageID><Name>AcademicYearCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1174</LineageID><MappedToExistingDimensionLineageID>1030</MappedToExistingDimensionLineageID><Name>AcademicYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1175</LineageID><MappedToExistingDimensionLineageID>1033</MappedToExistingDimensionLineageID><Name>TermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1176</LineageID><MappedToExistingDimensionLineageID>1036</MappedToExistingDimensionLineageID><Name>TermTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1177</LineageID><MappedToExistingDimensionLineageID>1039</MappedToExistingDimensionLineageID><Name>TermType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1178</LineageID><MappedToExistingDimensionLineageID>1042</MappedToExistingDimensionLineageID><Name>ActiveTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1179</LineageID><MappedToExistingDimensionLineageID>1045</MappedToExistingDimensionLineageID><Name>DefaultTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1180</LineageID><MappedToExistingDimensionLineageID>1048</MappedToExistingDimensionLineageID><Name>PriorYearTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1181</LineageID><MappedToExistingDimensionLineageID>1051</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1182</LineageID><MappedToExistingDimensionLineageID>1054</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1183</LineageID><MappedToExistingDimensionLineageID>1057</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1377</LineageID><MappedToExistingDimensionLineageID>1372</MappedToExistingDimensionLineageID><Name>RelativeDay</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1545</LineageID><MappedToExistingDimensionLineageID>1534</MappedToExistingDimensionLineageID><Name>StateReportingTermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1546</LineageID><MappedToExistingDimensionLineageID>1537</MappedToExistingDimensionLineageID><Name>StateReportingTermSequence</Name></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>629</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>630</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1232</LineageID><MappedToExistingDimensionLineageID>1012</MappedToExistingDimensionLineageID><Name>TermSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1233</LineageID><MappedToExistingDimensionLineageID>1015</MappedToExistingDimensionLineageID><Name>TermAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1234</LineageID><MappedToExistingDimensionLineageID>1018</MappedToExistingDimensionLineageID><Name>TermStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1235</LineageID><MappedToExistingDimensionLineageID>1021</MappedToExistingDimensionLineageID><Name>TermEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1236</LineageID><MappedToExistingDimensionLineageID>1024</MappedToExistingDimensionLineageID><Name>TermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1237</LineageID><MappedToExistingDimensionLineageID>1027</MappedToExistingDimensionLineageID><Name>AcademicYearCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1238</LineageID><MappedToExistingDimensionLineageID>1030</MappedToExistingDimensionLineageID><Name>AcademicYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1239</LineageID><MappedToExistingDimensionLineageID>1033</MappedToExistingDimensionLineageID><Name>TermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1240</LineageID><MappedToExistingDimensionLineageID>1036</MappedToExistingDimensionLineageID><Name>TermTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1241</LineageID><MappedToExistingDimensionLineageID>1039</MappedToExistingDimensionLineageID><Name>TermType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1242</LineageID><MappedToExistingDimensionLineageID>1042</MappedToExistingDimensionLineageID><Name>ActiveTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1243</LineageID><MappedToExistingDimensionLineageID>1045</MappedToExistingDimensionLineageID><Name>DefaultTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1244</LineageID><MappedToExistingDimensionLineageID>1048</MappedToExistingDimensionLineageID><Name>PriorYearTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1245</LineageID><MappedToExistingDimensionLineageID>1051</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1246</LineageID><MappedToExistingDimensionLineageID>1054</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1247</LineageID><MappedToExistingDimensionLineageID>1057</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1381</LineageID><MappedToExistingDimensionLineageID>1372</MappedToExistingDimensionLineageID><Name>RelativeDay</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1553</LineageID><MappedToExistingDimensionLineageID>1534</MappedToExistingDimensionLineageID><Name>StateReportingTermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1554</LineageID><MappedToExistingDimensionLineageID>1537</MappedToExistingDimensionLineageID><Name>StateReportingTermSequence</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Existing Dimension Columns |
<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StagedTermSK</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1311</SourceSystemLineageID><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TermSK</Name><LineageID>1012</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>SRCTermAK</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1314</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TermAK</Name><LineageID>1015</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCTermStartDate</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1317</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TermStartDate</Name><LineageID>1018</LineageID><DataType>133</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCTermEndDate</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1320</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TermEndDate</Name><LineageID>1021</LineageID><DataType>133</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCTermTitle</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1323</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TermTitle</Name><LineageID>1024</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCAcademicYearCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1326</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AcademicYearCode</Name><LineageID>1027</LineageID><DataType>129</DataType><Length>7</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCAcademicYear</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1329</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AcademicYear</Name><LineageID>1030</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCTermYear</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1332</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TermYear</Name><LineageID>1033</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCTermTypeCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1335</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TermTypeCode</Name><LineageID>1036</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCTermType</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1338</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TermType</Name><LineageID>1039</LineageID><DataType>129</DataType><Length>15</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCActiveTerm</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1341</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ActiveTerm</Name><LineageID>1042</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCDefaultTerm</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1344</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>DefaultTerm</Name><LineageID>1045</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCPriorYearTerm</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>1369</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PriorYearTerm</Name><LineageID>1048</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>7</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowIsCurrent</Name><LineageID>1051</LineageID><DataType>129</DataType><Length>1</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>1054</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>6</SCDColumnType><AllowNulls>True</AllowNulls><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>1057</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCRelativeDay</SourceSystemColumnName><SourceSystemLineageID>1347</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RelativeDay</Name><LineageID>1372</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCStateReportingTermYear</SourceSystemColumnName><SourceSystemLineageID>1528</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StateReportingTermYear</Name><LineageID>1534</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SRCStateReportingTermSequence</SourceSystemColumnName><SourceSystemLineageID>1531</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StateReportingTermSequence</Name><LineageID>1537</LineageID><DataType>17</DataType></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>627</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1200</LineageID><MappedToExistingDimensionLineageID>1012</MappedToExistingDimensionLineageID><Name>TermSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1201</LineageID><MappedToExistingDimensionLineageID>1015</MappedToExistingDimensionLineageID><Name>TermAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1202</LineageID><MappedToExistingDimensionLineageID>1018</MappedToExistingDimensionLineageID><Name>TermStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1203</LineageID><MappedToExistingDimensionLineageID>1021</MappedToExistingDimensionLineageID><Name>TermEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1204</LineageID><MappedToExistingDimensionLineageID>1024</MappedToExistingDimensionLineageID><Name>TermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1205</LineageID><MappedToExistingDimensionLineageID>1027</MappedToExistingDimensionLineageID><Name>AcademicYearCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1206</LineageID><MappedToExistingDimensionLineageID>1030</MappedToExistingDimensionLineageID><Name>AcademicYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1207</LineageID><MappedToExistingDimensionLineageID>1033</MappedToExistingDimensionLineageID><Name>TermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1208</LineageID><MappedToExistingDimensionLineageID>1036</MappedToExistingDimensionLineageID><Name>TermTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1209</LineageID><MappedToExistingDimensionLineageID>1039</MappedToExistingDimensionLineageID><Name>TermType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1210</LineageID><MappedToExistingDimensionLineageID>1042</MappedToExistingDimensionLineageID><Name>ActiveTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1211</LineageID><MappedToExistingDimensionLineageID>1045</MappedToExistingDimensionLineageID><Name>DefaultTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1212</LineageID><MappedToExistingDimensionLineageID>1048</MappedToExistingDimensionLineageID><Name>PriorYearTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1213</LineageID><MappedToExistingDimensionLineageID>1051</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1214</LineageID><MappedToExistingDimensionLineageID>1054</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1215</LineageID><MappedToExistingDimensionLineageID>1057</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1379</LineageID><MappedToExistingDimensionLineageID>1372</MappedToExistingDimensionLineageID><Name>RelativeDay</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1549</LineageID><MappedToExistingDimensionLineageID>1534</MappedToExistingDimensionLineageID><Name>StateReportingTermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1550</LineageID><MappedToExistingDimensionLineageID>1537</MappedToExistingDimensionLineageID><Name>StateReportingTermSequence</Name></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>625</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1152</LineageID><MappedToExistingDimensionLineageID>1012</MappedToExistingDimensionLineageID><Name>TermSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1153</LineageID><MappedToExistingDimensionLineageID>1015</MappedToExistingDimensionLineageID><Name>TermAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1154</LineageID><MappedToExistingDimensionLineageID>1018</MappedToExistingDimensionLineageID><Name>TermStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1155</LineageID><MappedToExistingDimensionLineageID>1021</MappedToExistingDimensionLineageID><Name>TermEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1156</LineageID><MappedToExistingDimensionLineageID>1024</MappedToExistingDimensionLineageID><Name>TermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1157</LineageID><MappedToExistingDimensionLineageID>1027</MappedToExistingDimensionLineageID><Name>AcademicYearCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1158</LineageID><MappedToExistingDimensionLineageID>1030</MappedToExistingDimensionLineageID><Name>AcademicYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1159</LineageID><MappedToExistingDimensionLineageID>1033</MappedToExistingDimensionLineageID><Name>TermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1160</LineageID><MappedToExistingDimensionLineageID>1036</MappedToExistingDimensionLineageID><Name>TermTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1161</LineageID><MappedToExistingDimensionLineageID>1039</MappedToExistingDimensionLineageID><Name>TermType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1162</LineageID><MappedToExistingDimensionLineageID>1042</MappedToExistingDimensionLineageID><Name>ActiveTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1163</LineageID><MappedToExistingDimensionLineageID>1045</MappedToExistingDimensionLineageID><Name>DefaultTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1164</LineageID><MappedToExistingDimensionLineageID>1048</MappedToExistingDimensionLineageID><Name>PriorYearTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1165</LineageID><MappedToExistingDimensionLineageID>1051</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1166</LineageID><MappedToExistingDimensionLineageID>1054</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1167</LineageID><MappedToExistingDimensionLineageID>1057</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1376</LineageID><MappedToExistingDimensionLineageID>1372</MappedToExistingDimensionLineageID><Name>RelativeDay</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1543</LineageID><MappedToExistingDimensionLineageID>1534</MappedToExistingDimensionLineageID><Name>StateReportingTermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1544</LineageID><MappedToExistingDimensionLineageID>1537</MappedToExistingDimensionLineageID><Name>StateReportingTermSequence</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>628</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1216</LineageID><MappedToExistingDimensionLineageID>1012</MappedToExistingDimensionLineageID><Name>TermSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1217</LineageID><MappedToExistingDimensionLineageID>1015</MappedToExistingDimensionLineageID><Name>TermAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1218</LineageID><MappedToExistingDimensionLineageID>1018</MappedToExistingDimensionLineageID><Name>TermStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1219</LineageID><MappedToExistingDimensionLineageID>1021</MappedToExistingDimensionLineageID><Name>TermEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1220</LineageID><MappedToExistingDimensionLineageID>1024</MappedToExistingDimensionLineageID><Name>TermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1221</LineageID><MappedToExistingDimensionLineageID>1027</MappedToExistingDimensionLineageID><Name>AcademicYearCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1222</LineageID><MappedToExistingDimensionLineageID>1030</MappedToExistingDimensionLineageID><Name>AcademicYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1223</LineageID><MappedToExistingDimensionLineageID>1033</MappedToExistingDimensionLineageID><Name>TermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1224</LineageID><MappedToExistingDimensionLineageID>1036</MappedToExistingDimensionLineageID><Name>TermTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1225</LineageID><MappedToExistingDimensionLineageID>1039</MappedToExistingDimensionLineageID><Name>TermType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1226</LineageID><MappedToExistingDimensionLineageID>1042</MappedToExistingDimensionLineageID><Name>ActiveTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1227</LineageID><MappedToExistingDimensionLineageID>1045</MappedToExistingDimensionLineageID><Name>DefaultTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1228</LineageID><MappedToExistingDimensionLineageID>1048</MappedToExistingDimensionLineageID><Name>PriorYearTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1229</LineageID><MappedToExistingDimensionLineageID>1051</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1230</LineageID><MappedToExistingDimensionLineageID>1054</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1231</LineageID><MappedToExistingDimensionLineageID>1057</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1380</LineageID><MappedToExistingDimensionLineageID>1372</MappedToExistingDimensionLineageID><Name>RelativeDay</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1551</LineageID><MappedToExistingDimensionLineageID>1534</MappedToExistingDimensionLineageID><Name>StateReportingTermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1552</LineageID><MappedToExistingDimensionLineageID>1537</MappedToExistingDimensionLineageID><Name>StateReportingTermSequence</Name></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 |
2 |
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>#1311</string><string>#1314</string><string>#1317</string><string>#1320</string><string>#1323</string><string>#1326</string><string>#1329</string><string>#1332</string><string>#1335</string><string>#1338</string><string>#1341</string><string>#1344</string><string>#1347</string><string>#1369</string><string>#1528</string><string>#1531</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>661</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>662</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>663</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>664</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>665</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>666</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>667</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>668</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>669</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>670</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>671</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>672</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>673</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>674</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>675</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>676</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>677</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>678</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>679</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>680</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>681</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>682</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>683</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>684</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>685</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>686</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>687</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Input Waiting On Row Processing</Name></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>1136</LineageID><MappedToExistingDimensionLineageID>1012</MappedToExistingDimensionLineageID><Name>TermSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1137</LineageID><MappedToExistingDimensionLineageID>1015</MappedToExistingDimensionLineageID><Name>TermAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1138</LineageID><MappedToExistingDimensionLineageID>1018</MappedToExistingDimensionLineageID><Name>TermStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1139</LineageID><MappedToExistingDimensionLineageID>1021</MappedToExistingDimensionLineageID><Name>TermEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1140</LineageID><MappedToExistingDimensionLineageID>1024</MappedToExistingDimensionLineageID><Name>TermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1141</LineageID><MappedToExistingDimensionLineageID>1027</MappedToExistingDimensionLineageID><Name>AcademicYearCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1142</LineageID><MappedToExistingDimensionLineageID>1030</MappedToExistingDimensionLineageID><Name>AcademicYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1143</LineageID><MappedToExistingDimensionLineageID>1033</MappedToExistingDimensionLineageID><Name>TermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1144</LineageID><MappedToExistingDimensionLineageID>1036</MappedToExistingDimensionLineageID><Name>TermTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1145</LineageID><MappedToExistingDimensionLineageID>1039</MappedToExistingDimensionLineageID><Name>TermType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1146</LineageID><MappedToExistingDimensionLineageID>1042</MappedToExistingDimensionLineageID><Name>ActiveTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1147</LineageID><MappedToExistingDimensionLineageID>1045</MappedToExistingDimensionLineageID><Name>DefaultTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1148</LineageID><MappedToExistingDimensionLineageID>1048</MappedToExistingDimensionLineageID><Name>PriorYearTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1149</LineageID><MappedToExistingDimensionLineageID>1051</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1150</LineageID><MappedToExistingDimensionLineageID>1054</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1151</LineageID><MappedToExistingDimensionLineageID>1057</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1375</LineageID><MappedToExistingDimensionLineageID>1372</MappedToExistingDimensionLineageID><Name>RelativeDay</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1541</LineageID><MappedToExistingDimensionLineageID>1534</MappedToExistingDimensionLineageID><Name>StateReportingTermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1542</LineageID><MappedToExistingDimensionLineageID>1537</MappedToExistingDimensionLineageID><Name>StateReportingTermSequence</Name></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>626</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1184</LineageID><MappedToExistingDimensionLineageID>1012</MappedToExistingDimensionLineageID><Name>TermSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1185</LineageID><MappedToExistingDimensionLineageID>1015</MappedToExistingDimensionLineageID><Name>TermAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1186</LineageID><MappedToExistingDimensionLineageID>1018</MappedToExistingDimensionLineageID><Name>TermStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1187</LineageID><MappedToExistingDimensionLineageID>1021</MappedToExistingDimensionLineageID><Name>TermEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1188</LineageID><MappedToExistingDimensionLineageID>1024</MappedToExistingDimensionLineageID><Name>TermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1189</LineageID><MappedToExistingDimensionLineageID>1027</MappedToExistingDimensionLineageID><Name>AcademicYearCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1190</LineageID><MappedToExistingDimensionLineageID>1030</MappedToExistingDimensionLineageID><Name>AcademicYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1191</LineageID><MappedToExistingDimensionLineageID>1033</MappedToExistingDimensionLineageID><Name>TermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1192</LineageID><MappedToExistingDimensionLineageID>1036</MappedToExistingDimensionLineageID><Name>TermTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1193</LineageID><MappedToExistingDimensionLineageID>1039</MappedToExistingDimensionLineageID><Name>TermType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1194</LineageID><MappedToExistingDimensionLineageID>1042</MappedToExistingDimensionLineageID><Name>ActiveTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1195</LineageID><MappedToExistingDimensionLineageID>1045</MappedToExistingDimensionLineageID><Name>DefaultTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1196</LineageID><MappedToExistingDimensionLineageID>1048</MappedToExistingDimensionLineageID><Name>PriorYearTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1197</LineageID><MappedToExistingDimensionLineageID>1051</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1198</LineageID><MappedToExistingDimensionLineageID>1054</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1199</LineageID><MappedToExistingDimensionLineageID>1057</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1378</LineageID><MappedToExistingDimensionLineageID>1372</MappedToExistingDimensionLineageID><Name>RelativeDay</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1547</LineageID><MappedToExistingDimensionLineageID>1534</MappedToExistingDimensionLineageID><Name>StateReportingTermYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1548</LineageID><MappedToExistingDimensionLineageID>1537</MappedToExistingDimensionLineageID><Name>StateReportingTermSequence</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Updated SCD1 Output Counter |
|
UserComponentTypeName |
PW.TaskFactory.DimensionMerge.DimensionMergeSCD, PW.TaskFactory.DimensionMergeSCD100, Version=1.0.0.0, Culture=neutral, PublicKeyToken=47acf905d0337c39 |
Input Columns
| Name | ID | LineageID |
AcademicYear |
1126 |
1030 |
AcademicYearCode |
1125 |
1027 |
ActiveTerm |
1130 |
1042 |
DefaultTerm |
1131 |
1045 |
PriorYearTerm |
1132 |
1048 |
RelativeDay |
1374 |
1372 |
RowEndDate |
1135 |
1057 |
RowIsCurrent |
1133 |
1051 |
RowStartDate |
1134 |
1054 |
StateReportingTermSequence |
1540 |
1537 |
StateReportingTermYear |
1539 |
1534 |
TermAK |
1121 |
1015 |
TermEndDate |
1123 |
1021 |
TermSK |
1120 |
1012 |
TermStartDate |
1122 |
1018 |
TermTitle |
1124 |
1024 |
TermType |
1129 |
1039 |
TermTypeCode |
1128 |
1036 |
TermYear |
1127 |
1033 |
SRCAcademicYear |
1358 |
1329 |
SRCAcademicYearCode |
1357 |
1326 |
SRCActiveTerm |
1362 |
1341 |
SRCDefaultTerm |
1363 |
1344 |
SRCPriorYearTerm |
1382 |
1369 |
SRCRelativeDay |
1383 |
1347 |
SRCStateReportingTermSequence |
1556 |
1531 |
SRCStateReportingTermYear |
1555 |
1528 |
SRCTermAK |
1353 |
1314 |
SRCTermEndDate |
1355 |
1320 |
SRCTermStartDate |
1354 |
1317 |
SRCTermTitle |
1356 |
1323 |
SRCTermType |
1361 |
1338 |
SRCTermTypeCode |
1360 |
1335 |
SRCTermYear |
1359 |
1332 |
StagedTermSK |
1385 |
1311 |
Output Columns
| Name | ID | LineageID |
Average number of rows held in cache |
654 |
654 |
Deleted Output Row Count |
640 |
640 |
Execution Instance |
632 |
632 |
Existing Dimension Input Row Count |
635 |
635 |
Invalid Input Output Row Count |
644 |
644 |
Machine Name |
633 |
633 |
Maximum number of rows held in cache |
653 |
653 |
Maximum Output Rows per Second |
660 |
660 |
Milliseconds of Downstream Backpressure Experienced |
659 |
659 |
Milliseconds of Upstream Backpressure Generated |
655 |
655 |
Milliseconds until first key match |
651 |
651 |
New Output Row Count |
639 |
639 |
Number of rows held in cache on first key match |
652 |
652 |
Package Name |
631 |
631 |
SCD1 Updated Output Row Count |
643 |
643 |
SCD2 Expired Output Row Count |
641 |
641 |
SCD2 New Output Row Count |
642 |
642 |
Sort Optimization Cache Hit Percentage |
656 |
656 |
Source System Input Row Count |
637 |
637 |
Special Members Input Row Count |
636 |
636 |
Start Time |
634 |
634 |
Time First Existing Dimension Row Received |
645 |
645 |
Time First Output Row Produced |
657 |
657 |
Time First Source System Row Received |
649 |
649 |
Time First Special Members Row Received |
647 |
647 |
Time Last Existing Dimension Row Received |
646 |
646 |
Time Last Output Row Produced |
658 |
658 |
Time Last Source System Row Received |
650 |
650 |
Time Last Special Members Row Received |
648 |
648 |
Unchanged Output Row Count |
638 |
638 |
AcademicYear |
1174 |
1174 |
AcademicYearCode |
1173 |
1173 |
ActiveTerm |
1178 |
1178 |
DefaultTerm |
1179 |
1179 |
PriorYearTerm |
1180 |
1180 |
RelativeDay |
1377 |
1377 |
RowEndDate |
1183 |
1183 |
RowIsCurrent |
1181 |
1181 |
RowStartDate |
1182 |
1182 |
StateReportingTermSequence |
1546 |
1546 |
StateReportingTermYear |
1545 |
1545 |
TermAK |
1169 |
1169 |
TermEndDate |
1171 |
1171 |
TermSK |
1168 |
1168 |
TermStartDate |
1170 |
1170 |
TermTitle |
1172 |
1172 |
TermType |
1177 |
1177 |
TermTypeCode |
1176 |
1176 |
TermYear |
1175 |
1175 |
AcademicYear |
1206 |
1206 |
AcademicYearCode |
1205 |
1205 |
ActiveTerm |
1210 |
1210 |
DefaultTerm |
1211 |
1211 |
PriorYearTerm |
1212 |
1212 |
RelativeDay |
1379 |
1379 |
Row Change Reason |
627 |
627 |
RowEndDate |
1215 |
1215 |
RowIsCurrent |
1213 |
1213 |
RowStartDate |
1214 |
1214 |
StateReportingTermSequence |
1550 |
1550 |
StateReportingTermYear |
1549 |
1549 |
TermAK |
1201 |
1201 |
TermEndDate |
1203 |
1203 |
TermSK |
1200 |
1200 |
TermStartDate |
1202 |
1202 |
TermTitle |
1204 |
1204 |
TermType |
1209 |
1209 |
TermTypeCode |
1208 |
1208 |
TermYear |
1207 |
1207 |
AcademicYear |
1238 |
1238 |
AcademicYearCode |
1237 |
1237 |
ActiveTerm |
1242 |
1242 |
DefaultTerm |
1243 |
1243 |
Invalid Input |
629 |
629 |
Invalid Input Error Description |
630 |
630 |
PriorYearTerm |
1244 |
1244 |
RelativeDay |
1381 |
1381 |
RowEndDate |
1247 |
1247 |
RowIsCurrent |
1245 |
1245 |
RowStartDate |
1246 |
1246 |
StateReportingTermSequence |
1554 |
1554 |
StateReportingTermYear |
1553 |
1553 |
TermAK |
1233 |
1233 |
TermEndDate |
1235 |
1235 |
TermSK |
1232 |
1232 |
TermStartDate |
1234 |
1234 |
TermTitle |
1236 |
1236 |
TermType |
1241 |
1241 |
TermTypeCode |
1240 |
1240 |
TermYear |
1239 |
1239 |
AcademicYear |
1158 |
1158 |
AcademicYearCode |
1157 |
1157 |
ActiveTerm |
1162 |
1162 |
DefaultTerm |
1163 |
1163 |
PriorYearTerm |
1164 |
1164 |
RelativeDay |
1376 |
1376 |
RowEndDate |
1167 |
1167 |
RowIsCurrent |
1165 |
1165 |
RowStartDate |
1166 |
1166 |
StateReportingTermSequence |
1544 |
1544 |
StateReportingTermYear |
1543 |
1543 |
TermAK |
1153 |
1153 |
TermEndDate |
1155 |
1155 |
TermSK |
1152 |
1152 |
TermStartDate |
1154 |
1154 |
TermTitle |
1156 |
1156 |
TermType |
1161 |
1161 |
TermTypeCode |
1160 |
1160 |
TermYear |
1159 |
1159 |
AcademicYear |
1222 |
1222 |
AcademicYearCode |
1221 |
1221 |
ActiveTerm |
1226 |
1226 |
DefaultTerm |
1227 |
1227 |
PriorYearTerm |
1228 |
1228 |
RelativeDay |
1380 |
1380 |
Row Change Reason |
628 |
628 |
RowEndDate |
1231 |
1231 |
RowIsCurrent |
1229 |
1229 |
RowStartDate |
1230 |
1230 |
StateReportingTermSequence |
1552 |
1552 |
StateReportingTermYear |
1551 |
1551 |
TermAK |
1217 |
1217 |
TermEndDate |
1219 |
1219 |
TermSK |
1216 |
1216 |
TermStartDate |
1218 |
1218 |
TermTitle |
1220 |
1220 |
TermType |
1225 |
1225 |
TermTypeCode |
1224 |
1224 |
TermYear |
1223 |
1223 |
Cache - ED Rows |
666 |
666 |
Cache - SM Rows |
667 |
667 |
Cache - SS Rows |
668 |
668 |
Input - ED Rows Received |
663 |
663 |
Input - SM Rows Received |
664 |
664 |
Input - SS Rows Received |
665 |
665 |
Interval End |
662 |
662 |
Interval Start |
661 |
661 |
Match Prep - Bulk Matched Rows |
677 |
677 |
Match Prep - Rows Built Into Work Units |
676 |
676 |
Match Prep - Work Unit Count |
678 |
678 |
Match Prep - Work Units Built |
675 |
675 |
Matching - Matched Key Queue Length |
679 |
679 |
Matching - Regular Determination |
681 |
681 |
Matching - Skipped Rows |
680 |
680 |
Matching - Sort Optimization Determination |
682 |
682 |
Matching - Undetermined |
683 |
683 |
Output - Deleted Rows Sent |
671 |
671 |
Output - Expired SCD2 Rows Sent |
673 |
673 |
Output - New Rows Sent |
670 |
670 |
Output - New SCD2 Rows Sent |
674 |
674 |
Output - Unchanged Rows Sent |
669 |
669 |
Output - Updated SCD1 Rows Sent |
672 |
672 |
Thread Delay - Input Waiting On Row Processing |
687 |
687 |
Thread Delay - Matching Waiting On Caching |
685 |
685 |
Thread Delay - Processing Waiting On Matching |
686 |
686 |
Thread Delay - Waiting For Input |
684 |
684 |
AcademicYear |
1142 |
1142 |
AcademicYearCode |
1141 |
1141 |
ActiveTerm |
1146 |
1146 |
DefaultTerm |
1147 |
1147 |
PriorYearTerm |
1148 |
1148 |
RelativeDay |
1375 |
1375 |
RowEndDate |
1151 |
1151 |
RowIsCurrent |
1149 |
1149 |
RowStartDate |
1150 |
1150 |
StateReportingTermSequence |
1542 |
1542 |
StateReportingTermYear |
1541 |
1541 |
TermAK |
1137 |
1137 |
TermEndDate |
1139 |
1139 |
TermSK |
1136 |
1136 |
TermStartDate |
1138 |
1138 |
TermTitle |
1140 |
1140 |
TermType |
1145 |
1145 |
TermTypeCode |
1144 |
1144 |
TermYear |
1143 |
1143 |
AcademicYear |
1190 |
1190 |
AcademicYearCode |
1189 |
1189 |
ActiveTerm |
1194 |
1194 |
DefaultTerm |
1195 |
1195 |
PriorYearTerm |
1196 |
1196 |
RelativeDay |
1378 |
1378 |
Row Change Reason |
626 |
626 |
RowEndDate |
1199 |
1199 |
RowIsCurrent |
1197 |
1197 |
RowStartDate |
1198 |
1198 |
StateReportingTermSequence |
1548 |
1548 |
StateReportingTermYear |
1547 |
1547 |
TermAK |
1185 |
1185 |
TermEndDate |
1187 |
1187 |
TermSK |
1184 |
1184 |
TermStartDate |
1186 |
1186 |
TermTitle |
1188 |
1188 |
TermType |
1193 |
1193 |
TermTypeCode |
1192 |
1192 |
TermYear |
1191 |
1191 |
| Powered by BI Documenter |
