|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | TF_SCD DimGlTransDetails |
| Description | |
| Up Stream Components | |
| Down Stream Components | |
| ID | 7345 |
| Component Class ID | {2E42D45B-F83C-400F-8D77-61DDE6A7DF29} |
| Contact Info | |
| Identification String | component "TF_SCD DimGlTransDetails" (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>7548</LineageID><MappedToExistingDimensionLineageID>7300</MappedToExistingDimensionLineageID><Name>GLDetailSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7549</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>GlDetailAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7550</LineageID><MappedToExistingDimensionLineageID>7306</MappedToExistingDimensionLineageID><Name>GlCalendarPeriod</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7551</LineageID><MappedToExistingDimensionLineageID>7309</MappedToExistingDimensionLineageID><Name>JournalNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7552</LineageID><MappedToExistingDimensionLineageID>7312</MappedToExistingDimensionLineageID><Name>LineNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7553</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>JournalTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7554</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>JournalType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7555</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>JournalGrouping</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7556</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>BudgetTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7557</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>BudgetType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7670</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7684</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7692</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Deleted Output Counter |
|
Error Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>1</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>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>7600</LineageID><MappedToExistingDimensionLineageID>7300</MappedToExistingDimensionLineageID><Name>GLDetailSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7601</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>GlDetailAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7602</LineageID><MappedToExistingDimensionLineageID>7306</MappedToExistingDimensionLineageID><Name>GlCalendarPeriod</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7603</LineageID><MappedToExistingDimensionLineageID>7309</MappedToExistingDimensionLineageID><Name>JournalNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7604</LineageID><MappedToExistingDimensionLineageID>7312</MappedToExistingDimensionLineageID><Name>LineNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7605</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>JournalTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7606</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>JournalType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7607</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>JournalGrouping</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7608</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>BudgetTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7609</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>BudgetType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7680</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7688</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7696</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Existing Dimension Columns |
<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><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><SpecialMembersColumnName /><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>6610</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><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>GLDetailSK</Name><LineageID>7300</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>GlDetailAK</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7273</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlDetailAK</Name><LineageID>7303</LineageID><DataType>129</DataType><Length>18</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlCalendarPeriod</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7276</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlCalendarPeriod</Name><LineageID>7306</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>JournalNumber</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7279</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>JournalNumber</Name><LineageID>7309</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LineNumber</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7282</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>LineNumber</Name><LineageID>7312</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>JournalTypeCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7285</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>JournalTypeCode</Name><LineageID>7315</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>JournalType</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7288</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>JournalType</Name><LineageID>7318</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>JournalGrouping</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7291</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>JournalGrouping</Name><LineageID>7321</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>BudgetTypeCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7294</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>BudgetTypeCode</Name><LineageID>7324</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>BudgetType</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7297</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>BudgetType</Name><LineageID>7327</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>7429</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7574</LineageID><MappedToExistingDimensionLineageID>7300</MappedToExistingDimensionLineageID><Name>GLDetailSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7575</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>GlDetailAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7576</LineageID><MappedToExistingDimensionLineageID>7306</MappedToExistingDimensionLineageID><Name>GlCalendarPeriod</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7577</LineageID><MappedToExistingDimensionLineageID>7309</MappedToExistingDimensionLineageID><Name>JournalNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7578</LineageID><MappedToExistingDimensionLineageID>7312</MappedToExistingDimensionLineageID><Name>LineNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7579</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>JournalTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7580</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>JournalType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7581</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>JournalGrouping</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7582</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>BudgetTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7583</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>BudgetType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7674</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7686</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7694</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Expired SCD2 Output Counter |
|
Hashing Algorithm |
0 |
Inferred Member False Value for Integer |
1 |
Inferred Member False Value for Strings |
N |
Inferred Member True Value for Integer |
0 |
Inferred Member True Value for Strings |
Y |
Invalid Input Output Counter |
|
Last Window Size |
0,0 |
Manage Surrogate Keys |
False |
New Output Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7427</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7533</LineageID><MappedToExistingDimensionLineageID>7300</MappedToExistingDimensionLineageID><Name>GLDetailSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7534</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>GlDetailAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7535</LineageID><MappedToExistingDimensionLineageID>7306</MappedToExistingDimensionLineageID><Name>GlCalendarPeriod</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7536</LineageID><MappedToExistingDimensionLineageID>7309</MappedToExistingDimensionLineageID><Name>JournalNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7537</LineageID><MappedToExistingDimensionLineageID>7312</MappedToExistingDimensionLineageID><Name>LineNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7538</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>JournalTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7539</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>JournalType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7540</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>JournalGrouping</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7541</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>BudgetTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7542</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>BudgetType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7667</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7683</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7691</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</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>7587</LineageID><MappedToExistingDimensionLineageID>7300</MappedToExistingDimensionLineageID><Name>GLDetailSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7588</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>GlDetailAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7589</LineageID><MappedToExistingDimensionLineageID>7306</MappedToExistingDimensionLineageID><Name>GlCalendarPeriod</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7590</LineageID><MappedToExistingDimensionLineageID>7309</MappedToExistingDimensionLineageID><Name>JournalNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7591</LineageID><MappedToExistingDimensionLineageID>7312</MappedToExistingDimensionLineageID><Name>LineNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7592</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>JournalTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7593</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>JournalType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7594</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>JournalGrouping</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7595</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>BudgetTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7596</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>BudgetType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7677</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7687</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7695</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></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>#7270</string><string>#7273</string><string>#7276</string><string>#7279</string><string>#7282</string><string>#7285</string><string>#7288</string><string>#7291</string><string>#7294</string><string>#7297</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>7520</LineageID><MappedToExistingDimensionLineageID>7300</MappedToExistingDimensionLineageID><Name>GLDetailSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7521</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>GlDetailAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7522</LineageID><MappedToExistingDimensionLineageID>7306</MappedToExistingDimensionLineageID><Name>GlCalendarPeriod</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7523</LineageID><MappedToExistingDimensionLineageID>7309</MappedToExistingDimensionLineageID><Name>JournalNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7524</LineageID><MappedToExistingDimensionLineageID>7312</MappedToExistingDimensionLineageID><Name>LineNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7525</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>JournalTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7526</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>JournalType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7527</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>JournalGrouping</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7528</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>BudgetTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7529</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>BudgetType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7666</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7682</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7690</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Unchanged Output Counter |
|
Update SCD1 Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7428</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7561</LineageID><MappedToExistingDimensionLineageID>7300</MappedToExistingDimensionLineageID><Name>GLDetailSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7562</LineageID><MappedToExistingDimensionLineageID>7303</MappedToExistingDimensionLineageID><Name>GlDetailAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7563</LineageID><MappedToExistingDimensionLineageID>7306</MappedToExistingDimensionLineageID><Name>GlCalendarPeriod</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7564</LineageID><MappedToExistingDimensionLineageID>7309</MappedToExistingDimensionLineageID><Name>JournalNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7565</LineageID><MappedToExistingDimensionLineageID>7312</MappedToExistingDimensionLineageID><Name>LineNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7566</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>JournalTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7567</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>JournalType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7568</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>JournalGrouping</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7569</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>BudgetTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7570</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>BudgetType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7671</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7685</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7693</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</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 |
BudgetType |
7505 |
7327 |
BudgetTypeCode |
7504 |
7324 |
GlCalendarPeriod |
7498 |
7306 |
GlDetailAK |
7497 |
7303 |
GLDetailSK |
7496 |
7300 |
JournalGrouping |
7503 |
7321 |
JournalNumber |
7499 |
7309 |
JournalType |
7502 |
7318 |
JournalTypeCode |
7501 |
7315 |
LineNumber |
7500 |
7312 |
RowEndDate |
7689 |
6613 |
RowIsCurrent |
7663 |
6607 |
RowStartDate |
7681 |
6610 |
BudgetType |
7514 |
7297 |
BudgetTypeCode |
7513 |
7294 |
GlCalendarPeriod |
7507 |
7276 |
GlDetailAK |
7506 |
7273 |
JournalGrouping |
7512 |
7291 |
JournalNumber |
7508 |
7279 |
JournalType |
7511 |
7288 |
JournalTypeCode |
7510 |
7285 |
LineNumber |
7509 |
7282 |
Output Columns
| Name | ID | LineageID |
RowEndDate |
7692 |
7692 |
RowIsCurrent |
7670 |
7670 |
RowStartDate |
7684 |
7684 |
RowEndDate |
7694 |
7694 |
RowIsCurrent |
7674 |
7674 |
RowStartDate |
7686 |
7686 |
RowEndDate |
7696 |
7696 |
RowIsCurrent |
7680 |
7680 |
RowStartDate |
7688 |
7688 |
BudgetType |
7542 |
7542 |
BudgetTypeCode |
7541 |
7541 |
GlCalendarPeriod |
7535 |
7535 |
GlDetailAK |
7534 |
7534 |
GLDetailSK |
7533 |
7533 |
JournalGrouping |
7540 |
7540 |
JournalNumber |
7536 |
7536 |
JournalType |
7539 |
7539 |
JournalTypeCode |
7538 |
7538 |
LineNumber |
7537 |
7537 |
RowEndDate |
7691 |
7691 |
RowIsCurrent |
7667 |
7667 |
RowStartDate |
7683 |
7683 |
RowEndDate |
7695 |
7695 |
RowIsCurrent |
7677 |
7677 |
RowStartDate |
7687 |
7687 |
RowEndDate |
7690 |
7690 |
RowIsCurrent |
7666 |
7666 |
RowStartDate |
7682 |
7682 |
BudgetType |
7570 |
7570 |
BudgetTypeCode |
7569 |
7569 |
GlCalendarPeriod |
7563 |
7563 |
GlDetailAK |
7562 |
7562 |
GLDetailSK |
7561 |
7561 |
JournalGrouping |
7568 |
7568 |
JournalNumber |
7564 |
7564 |
JournalType |
7567 |
7567 |
JournalTypeCode |
7566 |
7566 |
LineNumber |
7565 |
7565 |
RowEndDate |
7693 |
7693 |
RowIsCurrent |
7671 |
7671 |
RowStartDate |
7685 |
7685 |
| Powered by BI Documenter |
