|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | TF_SCD DimPurchaseOrder |
| Description | |
| Up Stream Components | |
| Down Stream Components | |
| ID | 7325 |
| Component Class ID | {2E42D45B-F83C-400F-8D77-61DDE6A7DF29} |
| Contact Info | |
| Identification String | component "TF_SCD DimPurchaseOrder" (7325) |
| 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>7478</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7479</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7480</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7481</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7482</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7483</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7484</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7485</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7486</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7487</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7488</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7489</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7490</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7491</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7492</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7493</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7494</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7495</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7496</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7497</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7498</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7499</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Number of rows held in cache on first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7500</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7501</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7502</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7503</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7504</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7505</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7506</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7507</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum Output Rows per Second</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Debugging Messages |
|
Deleted Output Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><LineageID>7592</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7593</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7594</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7598</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8281</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>PurchaseOrderSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8282</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>PurchaseOrderAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8283</LineageID><MappedToExistingDimensionLineageID>8166</MappedToExistingDimensionLineageID><Name>PurchaseOrderNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8284</LineageID><MappedToExistingDimensionLineageID>8169</MappedToExistingDimensionLineageID><Name>PoStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8285</LineageID><MappedToExistingDimensionLineageID>8172</MappedToExistingDimensionLineageID><Name>PoStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8286</LineageID><MappedToExistingDimensionLineageID>8175</MappedToExistingDimensionLineageID><Name>ReceivingStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8287</LineageID><MappedToExistingDimensionLineageID>8178</MappedToExistingDimensionLineageID><Name>ReceivingStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8288</LineageID><MappedToExistingDimensionLineageID>8181</MappedToExistingDimensionLineageID><Name>PayStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8289</LineageID><MappedToExistingDimensionLineageID>8184</MappedToExistingDimensionLineageID><Name>PayStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8290</LineageID><MappedToExistingDimensionLineageID>8187</MappedToExistingDimensionLineageID><Name>PoTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8291</LineageID><MappedToExistingDimensionLineageID>8190</MappedToExistingDimensionLineageID><Name>PoType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8292</LineageID><MappedToExistingDimensionLineageID>8193</MappedToExistingDimensionLineageID><Name>BuyerId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8293</LineageID><MappedToExistingDimensionLineageID>8196</MappedToExistingDimensionLineageID><Name>Buyer</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Deleted Output Counter |
|
Error Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>1</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7476</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7477</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7644</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7645</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7646</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7650</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8339</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>PurchaseOrderSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8340</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>PurchaseOrderAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8341</LineageID><MappedToExistingDimensionLineageID>8166</MappedToExistingDimensionLineageID><Name>PurchaseOrderNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8342</LineageID><MappedToExistingDimensionLineageID>8169</MappedToExistingDimensionLineageID><Name>PoStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8343</LineageID><MappedToExistingDimensionLineageID>8172</MappedToExistingDimensionLineageID><Name>PoStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8344</LineageID><MappedToExistingDimensionLineageID>8175</MappedToExistingDimensionLineageID><Name>ReceivingStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8345</LineageID><MappedToExistingDimensionLineageID>8178</MappedToExistingDimensionLineageID><Name>ReceivingStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8346</LineageID><MappedToExistingDimensionLineageID>8181</MappedToExistingDimensionLineageID><Name>PayStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8347</LineageID><MappedToExistingDimensionLineageID>8184</MappedToExistingDimensionLineageID><Name>PayStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8348</LineageID><MappedToExistingDimensionLineageID>8187</MappedToExistingDimensionLineageID><Name>PoTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8349</LineageID><MappedToExistingDimensionLineageID>8190</MappedToExistingDimensionLineageID><Name>PoType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8350</LineageID><MappedToExistingDimensionLineageID>8193</MappedToExistingDimensionLineageID><Name>BuyerId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8351</LineageID><MappedToExistingDimensionLineageID>8196</MappedToExistingDimensionLineageID><Name>Buyer</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>6607</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>6610</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>6613</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FiscalYear</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7279</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FiscalYear</Name><LineageID>7303</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PurchaseOrderSK</Name><LineageID>8160</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>PurchaseOrderAK</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8124</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PurchaseOrderAK</Name><LineageID>8163</LineageID><DataType>129</DataType><Length>12</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PurchaseOrderNumber</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8127</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PurchaseOrderNumber</Name><LineageID>8166</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PoStatusCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8130</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PoStatusCode</Name><LineageID>8169</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PoStatus</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8133</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PoStatus</Name><LineageID>8172</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReceivingStatusCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8136</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ReceivingStatusCode</Name><LineageID>8175</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReceivingStatus</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8139</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>ReceivingStatus</Name><LineageID>8178</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayStatusCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8142</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PayStatusCode</Name><LineageID>8181</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayStatus</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8145</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PayStatus</Name><LineageID>8184</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PoTypeCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8148</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PoTypeCode</Name><LineageID>8187</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PoType</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8151</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PoType</Name><LineageID>8190</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>BuyerId</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8154</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>BuyerId</Name><LineageID>8193</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Buyer</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>8157</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>Buyer</Name><LineageID>8196</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition></ArrayOfInputColumnDefinition> |
Existing Dimension Input Counter |
|
Expired SCD2 Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7474</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7618</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7619</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7620</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7624</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8309</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>PurchaseOrderSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8310</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>PurchaseOrderAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8311</LineageID><MappedToExistingDimensionLineageID>8166</MappedToExistingDimensionLineageID><Name>PurchaseOrderNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8312</LineageID><MappedToExistingDimensionLineageID>8169</MappedToExistingDimensionLineageID><Name>PoStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8313</LineageID><MappedToExistingDimensionLineageID>8172</MappedToExistingDimensionLineageID><Name>PoStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8314</LineageID><MappedToExistingDimensionLineageID>8175</MappedToExistingDimensionLineageID><Name>ReceivingStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8315</LineageID><MappedToExistingDimensionLineageID>8178</MappedToExistingDimensionLineageID><Name>ReceivingStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8316</LineageID><MappedToExistingDimensionLineageID>8181</MappedToExistingDimensionLineageID><Name>PayStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8317</LineageID><MappedToExistingDimensionLineageID>8184</MappedToExistingDimensionLineageID><Name>PayStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8318</LineageID><MappedToExistingDimensionLineageID>8187</MappedToExistingDimensionLineageID><Name>PoTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8319</LineageID><MappedToExistingDimensionLineageID>8190</MappedToExistingDimensionLineageID><Name>PoType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8320</LineageID><MappedToExistingDimensionLineageID>8193</MappedToExistingDimensionLineageID><Name>BuyerId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8321</LineageID><MappedToExistingDimensionLineageID>8196</MappedToExistingDimensionLineageID><Name>Buyer</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Expired SCD2 Output Counter |
|
Hashing Algorithm |
0 |
Inferred Member False Value for Integer |
1 |
Inferred Member False Value for Strings |
N |
Inferred Member True Value for Integer |
0 |
Inferred Member True Value for Strings |
Y |
Invalid Input Output Counter |
|
Last Window Size |
0,0 |
Manage Surrogate Keys |
False |
New Output Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7472</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7577</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7578</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7579</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7583</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8266</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>PurchaseOrderSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8267</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>PurchaseOrderAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8268</LineageID><MappedToExistingDimensionLineageID>8166</MappedToExistingDimensionLineageID><Name>PurchaseOrderNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8269</LineageID><MappedToExistingDimensionLineageID>8169</MappedToExistingDimensionLineageID><Name>PoStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8270</LineageID><MappedToExistingDimensionLineageID>8172</MappedToExistingDimensionLineageID><Name>PoStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8271</LineageID><MappedToExistingDimensionLineageID>8175</MappedToExistingDimensionLineageID><Name>ReceivingStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8272</LineageID><MappedToExistingDimensionLineageID>8178</MappedToExistingDimensionLineageID><Name>ReceivingStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8273</LineageID><MappedToExistingDimensionLineageID>8181</MappedToExistingDimensionLineageID><Name>PayStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8274</LineageID><MappedToExistingDimensionLineageID>8184</MappedToExistingDimensionLineageID><Name>PayStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8275</LineageID><MappedToExistingDimensionLineageID>8187</MappedToExistingDimensionLineageID><Name>PoTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8276</LineageID><MappedToExistingDimensionLineageID>8190</MappedToExistingDimensionLineageID><Name>PoType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8277</LineageID><MappedToExistingDimensionLineageID>8193</MappedToExistingDimensionLineageID><Name>BuyerId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8278</LineageID><MappedToExistingDimensionLineageID>8196</MappedToExistingDimensionLineageID><Name>Buyer</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
New Output Counter |
|
New SCD2 Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7475</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7631</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7632</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7633</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7637</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8324</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>PurchaseOrderSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8325</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>PurchaseOrderAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8326</LineageID><MappedToExistingDimensionLineageID>8166</MappedToExistingDimensionLineageID><Name>PurchaseOrderNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8327</LineageID><MappedToExistingDimensionLineageID>8169</MappedToExistingDimensionLineageID><Name>PoStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8328</LineageID><MappedToExistingDimensionLineageID>8172</MappedToExistingDimensionLineageID><Name>PoStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8329</LineageID><MappedToExistingDimensionLineageID>8175</MappedToExistingDimensionLineageID><Name>ReceivingStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8330</LineageID><MappedToExistingDimensionLineageID>8178</MappedToExistingDimensionLineageID><Name>ReceivingStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8331</LineageID><MappedToExistingDimensionLineageID>8181</MappedToExistingDimensionLineageID><Name>PayStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8332</LineageID><MappedToExistingDimensionLineageID>8184</MappedToExistingDimensionLineageID><Name>PayStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8333</LineageID><MappedToExistingDimensionLineageID>8187</MappedToExistingDimensionLineageID><Name>PoTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8334</LineageID><MappedToExistingDimensionLineageID>8190</MappedToExistingDimensionLineageID><Name>PoType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8335</LineageID><MappedToExistingDimensionLineageID>8193</MappedToExistingDimensionLineageID><Name>BuyerId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8336</LineageID><MappedToExistingDimensionLineageID>8196</MappedToExistingDimensionLineageID><Name>Buyer</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
New SCD2 Output Counter |
|
Number of Processing Threads |
0 |
Processing Timeout |
3600 |
SCD2 Current Member False Value for Integer |
1 |
SCD2 Current Member False Value for Strings |
N |
SCD2 Current Member True Value for Integer |
0 |
SCD2 Current Member True Value for Strings |
Y |
SCD2 Date Millisecond Precision |
3 |
SCD2 Desired Expiry For Current Records |
0 |
SCD2 Expiry Date Variable |
|
SCD2 Gap Granularity |
2 |
SCD2 Gap Offset |
1 |
SCD2 Now Variable |
System::ContainerStartTime |
SCD2 Specific Expiry Date |
<?xml version="1.0" encoding="utf-16"?><ArrayOfLong /> |
Source System Input Counter |
|
Source System Lineages |
<?xml version="1.0" encoding="utf-16"?><ArrayOfString><string>#6511</string><string>#6514</string><string>#7279</string><string>#8121</string><string>#8124</string><string>#8127</string><string>#8130</string><string>#8133</string><string>#8136</string><string>#8139</string><string>#8142</string><string>#8145</string><string>#8148</string><string>#8151</string><string>#8154</string><string>#8157</string></ArrayOfString> |
Special Members Input Counter |
|
Special Members Lineages |
<?xml version="1.0" encoding="utf-16"?><ArrayOfString /> |
Statistics Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><CanIncludeSCDColumnTypes>None</CanIncludeSCDColumnTypes><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7508</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7509</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7510</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7511</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7512</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7513</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7514</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7515</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7516</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7517</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7518</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7519</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7520</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7521</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7522</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7523</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7524</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7525</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7526</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7527</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7528</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7529</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7530</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7531</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7532</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7533</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7534</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Input Waiting On Row Processing</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Suppress Warnings About Optimizing Performance Through Sorted Inputs |
False |
Suppress Warnings About Optimizing Performance Through Surrogate Key Configuration |
False |
Suppress Warnings About Surrogate Key Configuration |
False |
Surrogate Key Increment |
1 |
Surrogate Key Increment By Variable? |
False |
Surrogate Key Increment Variable |
|
Surrogate Key Seed |
0 |
Surrogate Key Seed By Variable? |
False |
Surrogate Key Seed Variable |
|
Surrogate Key Seed Variable Guaranteed |
False |
Unchanged Output Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ArrayOfOutputColumnDefinition><OutputColumnDefinition><LineageID>7564</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7565</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7566</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7570</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8253</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>PurchaseOrderSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8254</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>PurchaseOrderAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8255</LineageID><MappedToExistingDimensionLineageID>8166</MappedToExistingDimensionLineageID><Name>PurchaseOrderNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8256</LineageID><MappedToExistingDimensionLineageID>8169</MappedToExistingDimensionLineageID><Name>PoStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8257</LineageID><MappedToExistingDimensionLineageID>8172</MappedToExistingDimensionLineageID><Name>PoStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8258</LineageID><MappedToExistingDimensionLineageID>8175</MappedToExistingDimensionLineageID><Name>ReceivingStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8259</LineageID><MappedToExistingDimensionLineageID>8178</MappedToExistingDimensionLineageID><Name>ReceivingStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8260</LineageID><MappedToExistingDimensionLineageID>8181</MappedToExistingDimensionLineageID><Name>PayStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8261</LineageID><MappedToExistingDimensionLineageID>8184</MappedToExistingDimensionLineageID><Name>PayStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8262</LineageID><MappedToExistingDimensionLineageID>8187</MappedToExistingDimensionLineageID><Name>PoTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8263</LineageID><MappedToExistingDimensionLineageID>8190</MappedToExistingDimensionLineageID><Name>PoType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8264</LineageID><MappedToExistingDimensionLineageID>8193</MappedToExistingDimensionLineageID><Name>BuyerId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8265</LineageID><MappedToExistingDimensionLineageID>8196</MappedToExistingDimensionLineageID><Name>Buyer</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Unchanged Output Counter |
|
Update SCD1 Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7473</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7605</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7606</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7607</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7611</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>FiscalYear</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8294</LineageID><MappedToExistingDimensionLineageID>8160</MappedToExistingDimensionLineageID><Name>PurchaseOrderSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8295</LineageID><MappedToExistingDimensionLineageID>8163</MappedToExistingDimensionLineageID><Name>PurchaseOrderAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8296</LineageID><MappedToExistingDimensionLineageID>8166</MappedToExistingDimensionLineageID><Name>PurchaseOrderNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8297</LineageID><MappedToExistingDimensionLineageID>8169</MappedToExistingDimensionLineageID><Name>PoStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8298</LineageID><MappedToExistingDimensionLineageID>8172</MappedToExistingDimensionLineageID><Name>PoStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8299</LineageID><MappedToExistingDimensionLineageID>8175</MappedToExistingDimensionLineageID><Name>ReceivingStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8300</LineageID><MappedToExistingDimensionLineageID>8178</MappedToExistingDimensionLineageID><Name>ReceivingStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8301</LineageID><MappedToExistingDimensionLineageID>8181</MappedToExistingDimensionLineageID><Name>PayStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8302</LineageID><MappedToExistingDimensionLineageID>8184</MappedToExistingDimensionLineageID><Name>PayStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8303</LineageID><MappedToExistingDimensionLineageID>8187</MappedToExistingDimensionLineageID><Name>PoTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8304</LineageID><MappedToExistingDimensionLineageID>8190</MappedToExistingDimensionLineageID><Name>PoType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8305</LineageID><MappedToExistingDimensionLineageID>8193</MappedToExistingDimensionLineageID><Name>BuyerId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8306</LineageID><MappedToExistingDimensionLineageID>8196</MappedToExistingDimensionLineageID><Name>Buyer</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 |
Buyer |
8238 |
8196 |
BuyerId |
8237 |
8193 |
FiscalYear |
7546 |
7303 |
PayStatus |
8234 |
8184 |
PayStatusCode |
8233 |
8181 |
PoStatus |
8230 |
8172 |
PoStatusCode |
8229 |
8169 |
PoType |
8236 |
8190 |
PoTypeCode |
8235 |
8187 |
PurchaseOrderAK |
8227 |
8163 |
PurchaseOrderNumber |
8228 |
8166 |
PurchaseOrderSK |
8226 |
8160 |
ReceivingStatus |
8232 |
8178 |
ReceivingStatusCode |
8231 |
8175 |
RowEndDate |
7542 |
6613 |
RowIsCurrent |
7540 |
6607 |
RowStartDate |
7541 |
6610 |
Buyer |
8250 |
8157 |
BuyerId |
8249 |
8154 |
FiscalYear |
7555 |
7279 |
PayStatus |
8246 |
8145 |
PayStatusCode |
8245 |
8142 |
PoStatus |
8242 |
8133 |
PoStatusCode |
8241 |
8130 |
PoType |
8248 |
8151 |
PoTypeCode |
8247 |
8148 |
PurchaseOrderAK |
8239 |
8124 |
PurchaseOrderNumber |
8240 |
8127 |
ReceivingStatus |
8244 |
8139 |
ReceivingStatusCode |
8243 |
8136 |
Output Columns
| Name | ID | LineageID |
Buyer |
8278 |
8278 |
BuyerId |
8277 |
8277 |
FiscalYear |
7583 |
7583 |
PayStatus |
8274 |
8274 |
PayStatusCode |
8273 |
8273 |
PoStatus |
8270 |
8270 |
PoStatusCode |
8269 |
8269 |
PoType |
8276 |
8276 |
PoTypeCode |
8275 |
8275 |
PurchaseOrderAK |
8267 |
8267 |
PurchaseOrderNumber |
8268 |
8268 |
PurchaseOrderSK |
8266 |
8266 |
ReceivingStatus |
8272 |
8272 |
ReceivingStatusCode |
8271 |
8271 |
RowEndDate |
7579 |
7579 |
RowIsCurrent |
7577 |
7577 |
RowStartDate |
7578 |
7578 |
Buyer |
8306 |
8306 |
BuyerId |
8305 |
8305 |
FiscalYear |
7611 |
7611 |
PayStatus |
8302 |
8302 |
PayStatusCode |
8301 |
8301 |
PoStatus |
8298 |
8298 |
PoStatusCode |
8297 |
8297 |
PoType |
8304 |
8304 |
PoTypeCode |
8303 |
8303 |
PurchaseOrderAK |
8295 |
8295 |
PurchaseOrderNumber |
8296 |
8296 |
PurchaseOrderSK |
8294 |
8294 |
ReceivingStatus |
8300 |
8300 |
ReceivingStatusCode |
8299 |
8299 |
RowEndDate |
7607 |
7607 |
RowIsCurrent |
7605 |
7605 |
RowStartDate |
7606 |
7606 |
| Powered by BI Documenter |
