|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | TF_SCD DimTimeType |
| Description | |
| Up Stream Components | |
| Down Stream Components | |
| ID | 7345 |
| Component Class ID | {2E42D45B-F83C-400F-8D77-61DDE6A7DF29} |
| Contact Info | |
| Identification String | component "TF_SCD DimTimeType" (7345) |
| 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>7433</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7434</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7435</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7436</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7437</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7438</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7439</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7440</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7441</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7442</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7443</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7444</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7445</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7446</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7447</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7448</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7449</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7450</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7451</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7452</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7453</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7454</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>7455</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7456</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7457</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7458</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7459</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7460</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7461</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7462</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>7670</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7684</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7692</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10085</LineageID><MappedToExistingDimensionLineageID>9965</MappedToExistingDimensionLineageID><Name>TimeTypeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10086</LineageID><MappedToExistingDimensionLineageID>9968</MappedToExistingDimensionLineageID><Name>TimeTypeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10087</LineageID><MappedToExistingDimensionLineageID>9971</MappedToExistingDimensionLineageID><Name>TimeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10088</LineageID><MappedToExistingDimensionLineageID>9974</MappedToExistingDimensionLineageID><Name>TimeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10089</LineageID><MappedToExistingDimensionLineageID>9977</MappedToExistingDimensionLineageID><Name>RegularTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10090</LineageID><MappedToExistingDimensionLineageID>9980</MappedToExistingDimensionLineageID><Name>PaidTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10091</LineageID><MappedToExistingDimensionLineageID>9983</MappedToExistingDimensionLineageID><Name>OvertimeTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10092</LineageID><MappedToExistingDimensionLineageID>9986</MappedToExistingDimensionLineageID><Name>LeaveTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10093</LineageID><MappedToExistingDimensionLineageID>9989</MappedToExistingDimensionLineageID><Name>LongTermTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10094</LineageID><MappedToExistingDimensionLineageID>9992</MappedToExistingDimensionLineageID><Name>AccruedTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10095</LineageID><MappedToExistingDimensionLineageID>9995</MappedToExistingDimensionLineageID><Name>EarnedTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10096</LineageID><MappedToExistingDimensionLineageID>9998</MappedToExistingDimensionLineageID><Name>SickPoolTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10097</LineageID><MappedToExistingDimensionLineageID>10001</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOptionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10098</LineageID><MappedToExistingDimensionLineageID>10004</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOption</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>7431</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7432</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7680</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7688</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7696</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10147</LineageID><MappedToExistingDimensionLineageID>9965</MappedToExistingDimensionLineageID><Name>TimeTypeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10148</LineageID><MappedToExistingDimensionLineageID>9968</MappedToExistingDimensionLineageID><Name>TimeTypeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10149</LineageID><MappedToExistingDimensionLineageID>9971</MappedToExistingDimensionLineageID><Name>TimeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10150</LineageID><MappedToExistingDimensionLineageID>9974</MappedToExistingDimensionLineageID><Name>TimeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10151</LineageID><MappedToExistingDimensionLineageID>9977</MappedToExistingDimensionLineageID><Name>RegularTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10152</LineageID><MappedToExistingDimensionLineageID>9980</MappedToExistingDimensionLineageID><Name>PaidTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10153</LineageID><MappedToExistingDimensionLineageID>9983</MappedToExistingDimensionLineageID><Name>OvertimeTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10154</LineageID><MappedToExistingDimensionLineageID>9986</MappedToExistingDimensionLineageID><Name>LeaveTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10155</LineageID><MappedToExistingDimensionLineageID>9989</MappedToExistingDimensionLineageID><Name>LongTermTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10156</LineageID><MappedToExistingDimensionLineageID>9992</MappedToExistingDimensionLineageID><Name>AccruedTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10157</LineageID><MappedToExistingDimensionLineageID>9995</MappedToExistingDimensionLineageID><Name>EarnedTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10158</LineageID><MappedToExistingDimensionLineageID>9998</MappedToExistingDimensionLineageID><Name>SickPoolTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10159</LineageID><MappedToExistingDimensionLineageID>10001</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOptionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10160</LineageID><MappedToExistingDimensionLineageID>10004</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOption</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Existing Dimension Columns |
<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>7</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowIsCurrent</Name><LineageID>8041</LineageID><DataType>130</DataType><Length>1</Length></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>8044</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>8047</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SCDColumnType>2</SCDColumnType><ColumnInformation><ColumnInformation><Name>TimeTypeSK</Name><LineageID>9965</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>TimeTypeAK</SourceSystemColumnName><SourceSystemLineageID>9926</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>TimeTypeAK</Name><LineageID>9968</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TimeTypeCode</SourceSystemColumnName><SourceSystemLineageID>9929</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>TimeTypeCode</Name><LineageID>9971</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TimeType</SourceSystemColumnName><SourceSystemLineageID>9932</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>TimeType</Name><LineageID>9974</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RegularTime</SourceSystemColumnName><SourceSystemLineageID>9935</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>RegularTime</Name><LineageID>9977</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PaidTime</SourceSystemColumnName><SourceSystemLineageID>9938</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PaidTime</Name><LineageID>9980</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>OvertimeTime</SourceSystemColumnName><SourceSystemLineageID>9941</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>OvertimeTime</Name><LineageID>9983</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LeaveTime</SourceSystemColumnName><SourceSystemLineageID>9944</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>LeaveTime</Name><LineageID>9986</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LongTermTime</SourceSystemColumnName><SourceSystemLineageID>9947</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>LongTermTime</Name><LineageID>9989</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AccruedTime</SourceSystemColumnName><SourceSystemLineageID>9950</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AccruedTime</Name><LineageID>9992</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EarnedTime</SourceSystemColumnName><SourceSystemLineageID>9953</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>EarnedTime</Name><LineageID>9995</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SickPoolTime</SourceSystemColumnName><SourceSystemLineageID>9956</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>SickPoolTime</Name><LineageID>9998</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TimeAttendReportingOptionCode</SourceSystemColumnName><SourceSystemLineageID>9959</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>TimeAttendReportingOptionCode</Name><LineageID>10001</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TimeAttendReportingOption</SourceSystemColumnName><SourceSystemLineageID>9962</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>TimeAttendReportingOption</Name><LineageID>10004</LineageID><DataType>129</DataType><Length>60</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>7429</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7674</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7686</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7694</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10115</LineageID><MappedToExistingDimensionLineageID>9965</MappedToExistingDimensionLineageID><Name>TimeTypeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10116</LineageID><MappedToExistingDimensionLineageID>9968</MappedToExistingDimensionLineageID><Name>TimeTypeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10117</LineageID><MappedToExistingDimensionLineageID>9971</MappedToExistingDimensionLineageID><Name>TimeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10118</LineageID><MappedToExistingDimensionLineageID>9974</MappedToExistingDimensionLineageID><Name>TimeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10119</LineageID><MappedToExistingDimensionLineageID>9977</MappedToExistingDimensionLineageID><Name>RegularTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10120</LineageID><MappedToExistingDimensionLineageID>9980</MappedToExistingDimensionLineageID><Name>PaidTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10121</LineageID><MappedToExistingDimensionLineageID>9983</MappedToExistingDimensionLineageID><Name>OvertimeTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10122</LineageID><MappedToExistingDimensionLineageID>9986</MappedToExistingDimensionLineageID><Name>LeaveTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10123</LineageID><MappedToExistingDimensionLineageID>9989</MappedToExistingDimensionLineageID><Name>LongTermTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10124</LineageID><MappedToExistingDimensionLineageID>9992</MappedToExistingDimensionLineageID><Name>AccruedTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10125</LineageID><MappedToExistingDimensionLineageID>9995</MappedToExistingDimensionLineageID><Name>EarnedTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10126</LineageID><MappedToExistingDimensionLineageID>9998</MappedToExistingDimensionLineageID><Name>SickPoolTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10127</LineageID><MappedToExistingDimensionLineageID>10001</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOptionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10128</LineageID><MappedToExistingDimensionLineageID>10004</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOption</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>7427</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7667</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7683</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7691</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10069</LineageID><MappedToExistingDimensionLineageID>9965</MappedToExistingDimensionLineageID><Name>TimeTypeSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10070</LineageID><MappedToExistingDimensionLineageID>9968</MappedToExistingDimensionLineageID><Name>TimeTypeAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10071</LineageID><MappedToExistingDimensionLineageID>9971</MappedToExistingDimensionLineageID><Name>TimeTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10072</LineageID><MappedToExistingDimensionLineageID>9974</MappedToExistingDimensionLineageID><Name>TimeType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10073</LineageID><MappedToExistingDimensionLineageID>9977</MappedToExistingDimensionLineageID><Name>RegularTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10074</LineageID><MappedToExistingDimensionLineageID>9980</MappedToExistingDimensionLineageID><Name>PaidTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10075</LineageID><MappedToExistingDimensionLineageID>9983</MappedToExistingDimensionLineageID><Name>OvertimeTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10076</LineageID><MappedToExistingDimensionLineageID>9986</MappedToExistingDimensionLineageID><Name>LeaveTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10077</LineageID><MappedToExistingDimensionLineageID>9989</MappedToExistingDimensionLineageID><Name>LongTermTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10078</LineageID><MappedToExistingDimensionLineageID>9992</MappedToExistingDimensionLineageID><Name>AccruedTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10079</LineageID><MappedToExistingDimensionLineageID>9995</MappedToExistingDimensionLineageID><Name>EarnedTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10080</LineageID><MappedToExistingDimensionLineageID>9998</MappedToExistingDimensionLineageID><Name>SickPoolTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10081</LineageID><MappedToExistingDimensionLineageID>10001</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOptionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10082</LineageID><MappedToExistingDimensionLineageID>10004</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOption</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>7430</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7677</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7687</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7695</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10131</LineageID><MappedToExistingDimensionLineageID>9965</MappedToExistingDimensionLineageID><Name>TimeTypeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10132</LineageID><MappedToExistingDimensionLineageID>9968</MappedToExistingDimensionLineageID><Name>TimeTypeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10133</LineageID><MappedToExistingDimensionLineageID>9971</MappedToExistingDimensionLineageID><Name>TimeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10134</LineageID><MappedToExistingDimensionLineageID>9974</MappedToExistingDimensionLineageID><Name>TimeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10135</LineageID><MappedToExistingDimensionLineageID>9977</MappedToExistingDimensionLineageID><Name>RegularTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10136</LineageID><MappedToExistingDimensionLineageID>9980</MappedToExistingDimensionLineageID><Name>PaidTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10137</LineageID><MappedToExistingDimensionLineageID>9983</MappedToExistingDimensionLineageID><Name>OvertimeTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10138</LineageID><MappedToExistingDimensionLineageID>9986</MappedToExistingDimensionLineageID><Name>LeaveTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10139</LineageID><MappedToExistingDimensionLineageID>9989</MappedToExistingDimensionLineageID><Name>LongTermTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10140</LineageID><MappedToExistingDimensionLineageID>9992</MappedToExistingDimensionLineageID><Name>AccruedTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10141</LineageID><MappedToExistingDimensionLineageID>9995</MappedToExistingDimensionLineageID><Name>EarnedTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10142</LineageID><MappedToExistingDimensionLineageID>9998</MappedToExistingDimensionLineageID><Name>SickPoolTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10143</LineageID><MappedToExistingDimensionLineageID>10001</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOptionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10144</LineageID><MappedToExistingDimensionLineageID>10004</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOption</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
New SCD2 Output Counter |
|
Number of Processing Threads |
2 |
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>#9923</string><string>#9926</string><string>#9929</string><string>#9932</string><string>#9935</string><string>#9938</string><string>#9941</string><string>#9944</string><string>#9947</string><string>#9950</string><string>#9953</string><string>#9956</string><string>#9959</string><string>#9962</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>7463</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7464</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7465</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7466</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7467</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7468</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7469</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7470</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7471</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7472</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7473</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7474</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7475</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7476</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7477</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7478</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7479</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7480</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7481</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7482</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7483</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7484</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7485</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7486</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7487</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7488</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7489</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>7666</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7682</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7690</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10055</LineageID><MappedToExistingDimensionLineageID>9965</MappedToExistingDimensionLineageID><Name>TimeTypeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10056</LineageID><MappedToExistingDimensionLineageID>9968</MappedToExistingDimensionLineageID><Name>TimeTypeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10057</LineageID><MappedToExistingDimensionLineageID>9971</MappedToExistingDimensionLineageID><Name>TimeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10058</LineageID><MappedToExistingDimensionLineageID>9974</MappedToExistingDimensionLineageID><Name>TimeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10059</LineageID><MappedToExistingDimensionLineageID>9977</MappedToExistingDimensionLineageID><Name>RegularTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10060</LineageID><MappedToExistingDimensionLineageID>9980</MappedToExistingDimensionLineageID><Name>PaidTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10061</LineageID><MappedToExistingDimensionLineageID>9983</MappedToExistingDimensionLineageID><Name>OvertimeTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10062</LineageID><MappedToExistingDimensionLineageID>9986</MappedToExistingDimensionLineageID><Name>LeaveTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10063</LineageID><MappedToExistingDimensionLineageID>9989</MappedToExistingDimensionLineageID><Name>LongTermTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10064</LineageID><MappedToExistingDimensionLineageID>9992</MappedToExistingDimensionLineageID><Name>AccruedTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10065</LineageID><MappedToExistingDimensionLineageID>9995</MappedToExistingDimensionLineageID><Name>EarnedTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10066</LineageID><MappedToExistingDimensionLineageID>9998</MappedToExistingDimensionLineageID><Name>SickPoolTime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10067</LineageID><MappedToExistingDimensionLineageID>10001</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOptionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>10068</LineageID><MappedToExistingDimensionLineageID>10004</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOption</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>8373</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7671</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7685</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7693</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10099</LineageID><MappedToExistingDimensionLineageID>9965</MappedToExistingDimensionLineageID><Name>TimeTypeSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10100</LineageID><MappedToExistingDimensionLineageID>9968</MappedToExistingDimensionLineageID><Name>TimeTypeAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10101</LineageID><MappedToExistingDimensionLineageID>9971</MappedToExistingDimensionLineageID><Name>TimeTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10102</LineageID><MappedToExistingDimensionLineageID>9974</MappedToExistingDimensionLineageID><Name>TimeType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10103</LineageID><MappedToExistingDimensionLineageID>9977</MappedToExistingDimensionLineageID><Name>RegularTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10104</LineageID><MappedToExistingDimensionLineageID>9980</MappedToExistingDimensionLineageID><Name>PaidTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10105</LineageID><MappedToExistingDimensionLineageID>9983</MappedToExistingDimensionLineageID><Name>OvertimeTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10106</LineageID><MappedToExistingDimensionLineageID>9986</MappedToExistingDimensionLineageID><Name>LeaveTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10107</LineageID><MappedToExistingDimensionLineageID>9989</MappedToExistingDimensionLineageID><Name>LongTermTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10108</LineageID><MappedToExistingDimensionLineageID>9992</MappedToExistingDimensionLineageID><Name>AccruedTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10109</LineageID><MappedToExistingDimensionLineageID>9995</MappedToExistingDimensionLineageID><Name>EarnedTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10110</LineageID><MappedToExistingDimensionLineageID>9998</MappedToExistingDimensionLineageID><Name>SickPoolTime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10111</LineageID><MappedToExistingDimensionLineageID>10001</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOptionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>10112</LineageID><MappedToExistingDimensionLineageID>10004</MappedToExistingDimensionLineageID><Name>TimeAttendReportingOption</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 |
AccruedTime |
10035 |
9992 |
EarnedTime |
10036 |
9995 |
LeaveTime |
10033 |
9986 |
LongTermTime |
10034 |
9989 |
OvertimeTime |
10032 |
9983 |
PaidTime |
10031 |
9980 |
RegularTime |
10030 |
9977 |
RowEndDate |
8149 |
8047 |
RowIsCurrent |
8147 |
8041 |
RowStartDate |
8148 |
8044 |
SickPoolTime |
10037 |
9998 |
TimeAttendReportingOption |
10039 |
10004 |
TimeAttendReportingOptionCode |
10038 |
10001 |
TimeType |
10029 |
9974 |
TimeTypeAK |
10027 |
9968 |
TimeTypeCode |
10028 |
9971 |
TimeTypeSK |
10026 |
9965 |
AccruedTime |
10048 |
9950 |
EarnedTime |
10049 |
9953 |
LeaveTime |
10046 |
9944 |
LongTermTime |
10047 |
9947 |
OvertimeTime |
10045 |
9941 |
PaidTime |
10044 |
9938 |
RegularTime |
10043 |
9935 |
SickPoolTime |
10050 |
9956 |
TimeAttendReportingOption |
10052 |
9962 |
TimeAttendReportingOptionCode |
10051 |
9959 |
TimeType |
10042 |
9932 |
TimeTypeAK |
10040 |
9926 |
TimeTypeCode |
10041 |
9929 |
Output Columns
| Name | ID | LineageID |
AccruedTime |
10078 |
10078 |
EarnedTime |
10079 |
10079 |
LeaveTime |
10076 |
10076 |
LongTermTime |
10077 |
10077 |
OvertimeTime |
10075 |
10075 |
PaidTime |
10074 |
10074 |
RegularTime |
10073 |
10073 |
RowEndDate |
7691 |
7691 |
RowIsCurrent |
7667 |
7667 |
RowStartDate |
7683 |
7683 |
SickPoolTime |
10080 |
10080 |
TimeAttendReportingOption |
10082 |
10082 |
TimeAttendReportingOptionCode |
10081 |
10081 |
TimeType |
10072 |
10072 |
TimeTypeAK |
10070 |
10070 |
TimeTypeCode |
10071 |
10071 |
TimeTypeSK |
10069 |
10069 |
AccruedTime |
10108 |
10108 |
EarnedTime |
10109 |
10109 |
LeaveTime |
10106 |
10106 |
LongTermTime |
10107 |
10107 |
OvertimeTime |
10105 |
10105 |
PaidTime |
10104 |
10104 |
RegularTime |
10103 |
10103 |
Row Change Reason |
8373 |
8373 |
RowEndDate |
7693 |
7693 |
RowIsCurrent |
7671 |
7671 |
RowStartDate |
7685 |
7685 |
SickPoolTime |
10110 |
10110 |
TimeAttendReportingOption |
10112 |
10112 |
TimeAttendReportingOptionCode |
10111 |
10111 |
TimeType |
10102 |
10102 |
TimeTypeAK |
10100 |
10100 |
TimeTypeCode |
10101 |
10101 |
TimeTypeSK |
10099 |
10099 |
| Powered by BI Documenter |
