|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | TF SCD User |
| Description | |
| Up Stream Components | |
| Down Stream Components | |
| ID | 6677 |
| Component Class ID | {2E42D45B-F83C-400F-8D77-61DDE6A7DF29} |
| Contact Info | |
| Identification String | component "TF SCD User" (6677) |
| 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>6765</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6766</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6767</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6768</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6769</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6770</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6771</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6772</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6773</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6774</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6775</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6776</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6777</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6778</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6779</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6780</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6781</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6782</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6783</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6784</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6785</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6786</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>6787</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6788</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6789</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6790</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6791</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6792</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6793</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6794</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>6982</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6983</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6984</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7298</LineageID><MappedToExistingDimensionLineageID>7276</MappedToExistingDimensionLineageID><Name>UserSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7299</LineageID><MappedToExistingDimensionLineageID>7279</MappedToExistingDimensionLineageID><Name>DomainUserId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7300</LineageID><MappedToExistingDimensionLineageID>7282</MappedToExistingDimensionLineageID><Name>ApplicationUserId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7396</LineageID><MappedToExistingDimensionLineageID>7386</MappedToExistingDimensionLineageID><Name>UserName</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>6763</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6764</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7110</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7111</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7112</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7316</LineageID><MappedToExistingDimensionLineageID>7276</MappedToExistingDimensionLineageID><Name>UserSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7317</LineageID><MappedToExistingDimensionLineageID>7279</MappedToExistingDimensionLineageID><Name>DomainUserId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7318</LineageID><MappedToExistingDimensionLineageID>7282</MappedToExistingDimensionLineageID><Name>ApplicationUserId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7406</LineageID><MappedToExistingDimensionLineageID>7386</MappedToExistingDimensionLineageID><Name>UserName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Existing Dimension Columns |
<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SCDColumnType>7</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowIsCurrent</Name><LineageID>6607</LineageID><DataType>129</DataType><Length>1</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>6610</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>6613</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>UserSK</Name><LineageID>7276</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>DashboardId</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7344</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>DomainUserId</Name><LineageID>7279</LineageID><DataType>129</DataType><Length>25</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>ApplicationUserId</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7285</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ApplicationUserId</Name><LineageID>7282</LineageID><DataType>129</DataType><Length>25</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>UserName</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7368</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>UserName</Name><LineageID>7386</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition></ArrayOfInputColumnDefinition> |
Existing Dimension Input Counter |
|
Expired SCD2 Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6761</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7046</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7047</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7048</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7306</LineageID><MappedToExistingDimensionLineageID>7276</MappedToExistingDimensionLineageID><Name>UserSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7307</LineageID><MappedToExistingDimensionLineageID>7279</MappedToExistingDimensionLineageID><Name>DomainUserId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7308</LineageID><MappedToExistingDimensionLineageID>7282</MappedToExistingDimensionLineageID><Name>ApplicationUserId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7400</LineageID><MappedToExistingDimensionLineageID>7386</MappedToExistingDimensionLineageID><Name>UserName</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>6759</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6948</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6949</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6950</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7293</LineageID><MappedToExistingDimensionLineageID>7276</MappedToExistingDimensionLineageID><Name>UserSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7294</LineageID><MappedToExistingDimensionLineageID>7279</MappedToExistingDimensionLineageID><Name>DomainUserId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7295</LineageID><MappedToExistingDimensionLineageID>7282</MappedToExistingDimensionLineageID><Name>ApplicationUserId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7393</LineageID><MappedToExistingDimensionLineageID>7386</MappedToExistingDimensionLineageID><Name>UserName</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>6762</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7078</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7079</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7080</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7311</LineageID><MappedToExistingDimensionLineageID>7276</MappedToExistingDimensionLineageID><Name>UserSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7312</LineageID><MappedToExistingDimensionLineageID>7279</MappedToExistingDimensionLineageID><Name>DomainUserId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7313</LineageID><MappedToExistingDimensionLineageID>7282</MappedToExistingDimensionLineageID><Name>ApplicationUserId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7403</LineageID><MappedToExistingDimensionLineageID>7386</MappedToExistingDimensionLineageID><Name>UserName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
New SCD2 Output Counter |
|
Number of Processing Threads |
0 |
Processing Timeout |
3600 |
SCD2 Current Member False Value for Integer |
1 |
SCD2 Current Member False Value for Strings |
N |
SCD2 Current Member True Value for Integer |
0 |
SCD2 Current Member True Value for Strings |
Y |
SCD2 Date Millisecond Precision |
3 |
SCD2 Desired Expiry For Current Records |
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>#7285</string><string>#7368</string><string>#7412</string><string>#7415</string><string>#7418</string><string>#7344</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>6795</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6796</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6797</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6798</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6799</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6800</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6801</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6802</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6803</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6804</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6805</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6806</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6807</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6808</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6809</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6810</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6811</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6812</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6813</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6814</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6815</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6816</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6817</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6818</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6819</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6820</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6821</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>6916</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6917</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6918</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7290</LineageID><MappedToExistingDimensionLineageID>7276</MappedToExistingDimensionLineageID><Name>UserSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7291</LineageID><MappedToExistingDimensionLineageID>7279</MappedToExistingDimensionLineageID><Name>DomainUserId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7292</LineageID><MappedToExistingDimensionLineageID>7282</MappedToExistingDimensionLineageID><Name>ApplicationUserId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7392</LineageID><MappedToExistingDimensionLineageID>7386</MappedToExistingDimensionLineageID><Name>UserName</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>6760</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7357</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7358</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7359</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7301</LineageID><MappedToExistingDimensionLineageID>7276</MappedToExistingDimensionLineageID><Name>UserSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7302</LineageID><MappedToExistingDimensionLineageID>7279</MappedToExistingDimensionLineageID><Name>DomainUserId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7303</LineageID><MappedToExistingDimensionLineageID>7282</MappedToExistingDimensionLineageID><Name>ApplicationUserId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7397</LineageID><MappedToExistingDimensionLineageID>7386</MappedToExistingDimensionLineageID><Name>UserName</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 |
ApplicationUserId |
7289 |
7282 |
DomainUserId |
7288 |
7279 |
RowEndDate |
6856 |
6613 |
RowIsCurrent |
6854 |
6607 |
RowStartDate |
6855 |
6610 |
UserName |
7388 |
7386 |
UserSK |
7287 |
7276 |
ApplicationUserId |
7320 |
7285 |
DashboardId |
7347 |
7344 |
UserName |
7389 |
7368 |
Output Columns
| Name | ID | LineageID |
ApplicationUserId |
7295 |
7295 |
DomainUserId |
7294 |
7294 |
RowEndDate |
6950 |
6950 |
RowIsCurrent |
6948 |
6948 |
RowStartDate |
6949 |
6949 |
UserName |
7393 |
7393 |
UserSK |
7293 |
7293 |
ApplicationUserId |
7303 |
7303 |
DomainUserId |
7302 |
7302 |
RowEndDate |
7359 |
7359 |
RowIsCurrent |
7357 |
7357 |
RowStartDate |
7358 |
7358 |
UserName |
7397 |
7397 |
UserSK |
7301 |
7301 |
| Powered by BI Documenter |
