DimProgramRetentionCohortLoad
 TF_SCD Program Retention Cohort Slowly Changing Dimension Process (Component)
  Properties
Property Value
Name TF_SCD Program Retention Cohort Slowly Changing Dimension Process
Description
Up Stream Components
Down Stream Components
ID 3956
Component Class ID {2E42D45B-F83C-400F-8D77-61DDE6A7DF29}
Contact Info
Identification String component "TF_SCD Program Retention Cohort Slowly Changing Dimension Process" (3956)
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>4044</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4045</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4046</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4047</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4048</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4049</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4050</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4051</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4052</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4053</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4054</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4055</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4056</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4057</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4058</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4059</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4060</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4061</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4062</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4063</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4064</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4065</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>4066</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4067</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4068</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4069</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4070</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4071</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4072</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4073</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>4317</LineageID><MappedToExistingDimensionLineageID>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4318</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4319</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5846</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5849</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5850</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5860</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5861</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7020</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7021</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7022</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7586</LineageID><MappedToExistingDimensionLineageID>7448</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7587</LineageID><MappedToExistingDimensionLineageID>7451</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7588</LineageID><MappedToExistingDimensionLineageID>7454</MappedToExistingDimensionLineageID><Name>CIPCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7589</LineageID><MappedToExistingDimensionLineageID>7457</MappedToExistingDimensionLineageID><Name>CIP</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7590</LineageID><MappedToExistingDimensionLineageID>7460</MappedToExistingDimensionLineageID><Name>AgeAtProgramRetentionCohort</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7591</LineageID><MappedToExistingDimensionLineageID>7463</MappedToExistingDimensionLineageID><Name>AgeRangeAtProgramRetentionCohort</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7592</LineageID><MappedToExistingDimensionLineageID>7466</MappedToExistingDimensionLineageID><Name>SwitchedProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7593</LineageID><MappedToExistingDimensionLineageID>7469</MappedToExistingDimensionLineageID><Name>SwitchedProgram</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7594</LineageID><MappedToExistingDimensionLineageID>7472</MappedToExistingDimensionLineageID><Name>SwitchedTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7595</LineageID><MappedToExistingDimensionLineageID>7475</MappedToExistingDimensionLineageID><Name>SwitchedTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7596</LineageID><MappedToExistingDimensionLineageID>7478</MappedToExistingDimensionLineageID><Name>SwitchedAwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7597</LineageID><MappedToExistingDimensionLineageID>7481</MappedToExistingDimensionLineageID><Name>SwitchedAwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7598</LineageID><MappedToExistingDimensionLineageID>7484</MappedToExistingDimensionLineageID><Name>SwitchedCIPCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7599</LineageID><MappedToExistingDimensionLineageID>7487</MappedToExistingDimensionLineageID><Name>SwitchedCIP</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>4042</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4043</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4529</LineageID><MappedToExistingDimensionLineageID>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4530</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4531</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5978</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5981</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5982</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5992</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5993</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7054</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7055</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7056</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7648</LineageID><MappedToExistingDimensionLineageID>7448</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7649</LineageID><MappedToExistingDimensionLineageID>7451</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7650</LineageID><MappedToExistingDimensionLineageID>7454</MappedToExistingDimensionLineageID><Name>CIPCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7651</LineageID><MappedToExistingDimensionLineageID>7457</MappedToExistingDimensionLineageID><Name>CIP</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7652</LineageID><MappedToExistingDimensionLineageID>7460</MappedToExistingDimensionLineageID><Name>AgeAtProgramRetentionCohort</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7653</LineageID><MappedToExistingDimensionLineageID>7463</MappedToExistingDimensionLineageID><Name>AgeRangeAtProgramRetentionCohort</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7654</LineageID><MappedToExistingDimensionLineageID>7466</MappedToExistingDimensionLineageID><Name>SwitchedProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7655</LineageID><MappedToExistingDimensionLineageID>7469</MappedToExistingDimensionLineageID><Name>SwitchedProgram</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7656</LineageID><MappedToExistingDimensionLineageID>7472</MappedToExistingDimensionLineageID><Name>SwitchedTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7657</LineageID><MappedToExistingDimensionLineageID>7475</MappedToExistingDimensionLineageID><Name>SwitchedTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7658</LineageID><MappedToExistingDimensionLineageID>7478</MappedToExistingDimensionLineageID><Name>SwitchedAwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7659</LineageID><MappedToExistingDimensionLineageID>7481</MappedToExistingDimensionLineageID><Name>SwitchedAwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7660</LineageID><MappedToExistingDimensionLineageID>7484</MappedToExistingDimensionLineageID><Name>SwitchedCIPCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7661</LineageID><MappedToExistingDimensionLineageID>7487</MappedToExistingDimensionLineageID><Name>SwitchedCIP</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>3948</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>3951</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>3954</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StudentId</SourceSystemColumnName><SourceSystemLineageID>5450</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentId</Name><LineageID>5621</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ProgramCode</SourceSystemColumnName><SourceSystemLineageID>5459</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ProgramCode</Name><LineageID>5630</LineageID><DataType>129</DataType><Length>5</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Program</SourceSystemColumnName><SourceSystemLineageID>5462</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Program</Name><LineageID>5633</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AwardTypeCode</SourceSystemColumnName><SourceSystemLineageID>5492</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AwardTypeCode</Name><LineageID>5663</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AwardType</SourceSystemColumnName><SourceSystemLineageID>5495</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AwardType</Name><LineageID>5666</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CohortTerm</SourceSystemColumnName><SourceSystemLineageID>6957</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CohortTerm</Name><LineageID>6936</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CohortTermTitle</SourceSystemColumnName><SourceSystemLineageID>6960</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CohortTermTitle</Name><LineageID>6939</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ProgramAdmitStatus</SourceSystemColumnName><SourceSystemLineageID>6963</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ProgramAdmitStatus</Name><LineageID>6942</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ProgramRetentionCohortSK</Name><LineageID>7448</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>ProgramRetentionCohortAK</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7409</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ProgramRetentionCohortAK</Name><LineageID>7451</LineageID><DataType>129</DataType><Length>20</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CIPCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7412</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CIPCode</Name><LineageID>7454</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CIP</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7415</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CIP</Name><LineageID>7457</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AgeAtProgramRetentionCohort</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7418</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AgeAtProgramRetentionCohort</Name><LineageID>7460</LineageID><DataType>2</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AgeRangeAtProgramRetentionCohort</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7421</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AgeRangeAtProgramRetentionCohort</Name><LineageID>7463</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SwitchedProgramCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7424</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SwitchedProgramCode</Name><LineageID>7466</LineageID><DataType>129</DataType><Length>5</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SwitchedProgram</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7427</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SwitchedProgram</Name><LineageID>7469</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SwitchedTerm</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7430</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SwitchedTerm</Name><LineageID>7472</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SwitchedTermTitle</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7433</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SwitchedTermTitle</Name><LineageID>7475</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SwitchedAwardTypeCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7436</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SwitchedAwardTypeCode</Name><LineageID>7478</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SwitchedAwardType</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7439</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SwitchedAwardType</Name><LineageID>7481</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SwitchedCIPCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7442</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SwitchedCIPCode</Name><LineageID>7484</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SwitchedCIP</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7445</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SwitchedCIP</Name><LineageID>7487</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>4040</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4423</LineageID><MappedToExistingDimensionLineageID>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4424</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4425</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5912</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5915</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5916</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5926</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5927</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7036</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7037</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7038</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7616</LineageID><MappedToExistingDimensionLineageID>7448</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7617</LineageID><MappedToExistingDimensionLineageID>7451</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7618</LineageID><MappedToExistingDimensionLineageID>7454</MappedToExistingDimensionLineageID><Name>CIPCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7619</LineageID><MappedToExistingDimensionLineageID>7457</MappedToExistingDimensionLineageID><Name>CIP</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7620</LineageID><MappedToExistingDimensionLineageID>7460</MappedToExistingDimensionLineageID><Name>AgeAtProgramRetentionCohort</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7621</LineageID><MappedToExistingDimensionLineageID>7463</MappedToExistingDimensionLineageID><Name>AgeRangeAtProgramRetentionCohort</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7622</LineageID><MappedToExistingDimensionLineageID>7466</MappedToExistingDimensionLineageID><Name>SwitchedProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7623</LineageID><MappedToExistingDimensionLineageID>7469</MappedToExistingDimensionLineageID><Name>SwitchedProgram</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7624</LineageID><MappedToExistingDimensionLineageID>7472</MappedToExistingDimensionLineageID><Name>SwitchedTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7625</LineageID><MappedToExistingDimensionLineageID>7475</MappedToExistingDimensionLineageID><Name>SwitchedTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7626</LineageID><MappedToExistingDimensionLineageID>7478</MappedToExistingDimensionLineageID><Name>SwitchedAwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7627</LineageID><MappedToExistingDimensionLineageID>7481</MappedToExistingDimensionLineageID><Name>SwitchedAwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7628</LineageID><MappedToExistingDimensionLineageID>7484</MappedToExistingDimensionLineageID><Name>SwitchedCIPCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7629</LineageID><MappedToExistingDimensionLineageID>7487</MappedToExistingDimensionLineageID><Name>SwitchedCIP</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
1321,816
Manage Surrogate Keys
False
New Output Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4038</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4262</LineageID><MappedToExistingDimensionLineageID>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4263</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4264</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5813</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5816</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5817</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5827</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5828</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7011</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7012</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7013</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7570</LineageID><MappedToExistingDimensionLineageID>7448</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7571</LineageID><MappedToExistingDimensionLineageID>7451</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7572</LineageID><MappedToExistingDimensionLineageID>7454</MappedToExistingDimensionLineageID><Name>CIPCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7573</LineageID><MappedToExistingDimensionLineageID>7457</MappedToExistingDimensionLineageID><Name>CIP</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7574</LineageID><MappedToExistingDimensionLineageID>7460</MappedToExistingDimensionLineageID><Name>AgeAtProgramRetentionCohort</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7575</LineageID><MappedToExistingDimensionLineageID>7463</MappedToExistingDimensionLineageID><Name>AgeRangeAtProgramRetentionCohort</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7576</LineageID><MappedToExistingDimensionLineageID>7466</MappedToExistingDimensionLineageID><Name>SwitchedProgramCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7577</LineageID><MappedToExistingDimensionLineageID>7469</MappedToExistingDimensionLineageID><Name>SwitchedProgram</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7578</LineageID><MappedToExistingDimensionLineageID>7472</MappedToExistingDimensionLineageID><Name>SwitchedTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7579</LineageID><MappedToExistingDimensionLineageID>7475</MappedToExistingDimensionLineageID><Name>SwitchedTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7580</LineageID><MappedToExistingDimensionLineageID>7478</MappedToExistingDimensionLineageID><Name>SwitchedAwardTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7581</LineageID><MappedToExistingDimensionLineageID>7481</MappedToExistingDimensionLineageID><Name>SwitchedAwardType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7582</LineageID><MappedToExistingDimensionLineageID>7484</MappedToExistingDimensionLineageID><Name>SwitchedCIPCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7583</LineageID><MappedToExistingDimensionLineageID>7487</MappedToExistingDimensionLineageID><Name>SwitchedCIP</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>4041</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4476</LineageID><MappedToExistingDimensionLineageID>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4477</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4478</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5945</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5948</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5949</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5959</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5960</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7045</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7046</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7047</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7632</LineageID><MappedToExistingDimensionLineageID>7448</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7633</LineageID><MappedToExistingDimensionLineageID>7451</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7634</LineageID><MappedToExistingDimensionLineageID>7454</MappedToExistingDimensionLineageID><Name>CIPCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7635</LineageID><MappedToExistingDimensionLineageID>7457</MappedToExistingDimensionLineageID><Name>CIP</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7636</LineageID><MappedToExistingDimensionLineageID>7460</MappedToExistingDimensionLineageID><Name>AgeAtProgramRetentionCohort</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7637</LineageID><MappedToExistingDimensionLineageID>7463</MappedToExistingDimensionLineageID><Name>AgeRangeAtProgramRetentionCohort</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7638</LineageID><MappedToExistingDimensionLineageID>7466</MappedToExistingDimensionLineageID><Name>SwitchedProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7639</LineageID><MappedToExistingDimensionLineageID>7469</MappedToExistingDimensionLineageID><Name>SwitchedProgram</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7640</LineageID><MappedToExistingDimensionLineageID>7472</MappedToExistingDimensionLineageID><Name>SwitchedTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7641</LineageID><MappedToExistingDimensionLineageID>7475</MappedToExistingDimensionLineageID><Name>SwitchedTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7642</LineageID><MappedToExistingDimensionLineageID>7478</MappedToExistingDimensionLineageID><Name>SwitchedAwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7643</LineageID><MappedToExistingDimensionLineageID>7481</MappedToExistingDimensionLineageID><Name>SwitchedAwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7644</LineageID><MappedToExistingDimensionLineageID>7484</MappedToExistingDimensionLineageID><Name>SwitchedCIPCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7645</LineageID><MappedToExistingDimensionLineageID>7487</MappedToExistingDimensionLineageID><Name>SwitchedCIP</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
New SCD2 Output Counter
Number of Processing Threads
2
Processing Timeout
3600
SCD2 Current Member False Value for Integer
1
SCD2 Current Member False Value for Strings
N
SCD2 Current Member True Value for Integer
0
SCD2 Current Member True Value for Strings
Y
SCD2 Date Millisecond Precision
3
SCD2 Desired Expiry For Current Records
2
SCD2 Expiry Date Variable
SCD2 Gap Granularity
2
SCD2 Gap Offset
1
SCD2 Now Variable
System::ContainerStartTime
SCD2 Specific Expiry Date
<?xml version="1.0" encoding="utf-16"?><ArrayOfLong />
Source System Input Counter
Source System Lineages
<?xml version="1.0" encoding="utf-16"?><ArrayOfString><string>#5450</string><string>#5459</string><string>#5462</string><string>#5492</string><string>#5495</string><string>#6957</string><string>#6960</string><string>#6963</string><string>#7406</string><string>#7409</string><string>#7412</string><string>#7415</string><string>#7418</string><string>#7421</string><string>#7424</string><string>#7427</string><string>#7430</string><string>#7433</string><string>#7436</string><string>#7439</string><string>#7442</string><string>#7445</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>4074</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4075</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4076</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4077</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4078</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4079</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4080</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4081</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4082</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4083</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4084</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4085</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4086</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4087</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4088</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4089</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4090</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4091</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4092</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4093</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4094</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4095</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4096</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4097</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4098</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4099</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4100</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>4209</LineageID><MappedToExistingDimensionLineageID>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4210</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4211</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5780</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5783</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5784</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5794</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5795</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7004</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7005</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7006</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7556</LineageID><MappedToExistingDimensionLineageID>7448</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7557</LineageID><MappedToExistingDimensionLineageID>7451</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7558</LineageID><MappedToExistingDimensionLineageID>7454</MappedToExistingDimensionLineageID><Name>CIPCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7559</LineageID><MappedToExistingDimensionLineageID>7457</MappedToExistingDimensionLineageID><Name>CIP</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7560</LineageID><MappedToExistingDimensionLineageID>7460</MappedToExistingDimensionLineageID><Name>AgeAtProgramRetentionCohort</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7561</LineageID><MappedToExistingDimensionLineageID>7463</MappedToExistingDimensionLineageID><Name>AgeRangeAtProgramRetentionCohort</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7562</LineageID><MappedToExistingDimensionLineageID>7466</MappedToExistingDimensionLineageID><Name>SwitchedProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7563</LineageID><MappedToExistingDimensionLineageID>7469</MappedToExistingDimensionLineageID><Name>SwitchedProgram</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7564</LineageID><MappedToExistingDimensionLineageID>7472</MappedToExistingDimensionLineageID><Name>SwitchedTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7565</LineageID><MappedToExistingDimensionLineageID>7475</MappedToExistingDimensionLineageID><Name>SwitchedTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7566</LineageID><MappedToExistingDimensionLineageID>7478</MappedToExistingDimensionLineageID><Name>SwitchedAwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7567</LineageID><MappedToExistingDimensionLineageID>7481</MappedToExistingDimensionLineageID><Name>SwitchedAwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7568</LineageID><MappedToExistingDimensionLineageID>7484</MappedToExistingDimensionLineageID><Name>SwitchedCIPCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7569</LineageID><MappedToExistingDimensionLineageID>7487</MappedToExistingDimensionLineageID><Name>SwitchedCIP</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Unchanged Output Counter
Update SCD1 Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4039</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4370</LineageID><MappedToExistingDimensionLineageID>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4371</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4372</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5879</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5882</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5883</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5893</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5894</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7027</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7028</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7029</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7600</LineageID><MappedToExistingDimensionLineageID>7448</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7601</LineageID><MappedToExistingDimensionLineageID>7451</MappedToExistingDimensionLineageID><Name>ProgramRetentionCohortAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7602</LineageID><MappedToExistingDimensionLineageID>7454</MappedToExistingDimensionLineageID><Name>CIPCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7603</LineageID><MappedToExistingDimensionLineageID>7457</MappedToExistingDimensionLineageID><Name>CIP</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7604</LineageID><MappedToExistingDimensionLineageID>7460</MappedToExistingDimensionLineageID><Name>AgeAtProgramRetentionCohort</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7605</LineageID><MappedToExistingDimensionLineageID>7463</MappedToExistingDimensionLineageID><Name>AgeRangeAtProgramRetentionCohort</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7606</LineageID><MappedToExistingDimensionLineageID>7466</MappedToExistingDimensionLineageID><Name>SwitchedProgramCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7607</LineageID><MappedToExistingDimensionLineageID>7469</MappedToExistingDimensionLineageID><Name>SwitchedProgram</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7608</LineageID><MappedToExistingDimensionLineageID>7472</MappedToExistingDimensionLineageID><Name>SwitchedTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7609</LineageID><MappedToExistingDimensionLineageID>7475</MappedToExistingDimensionLineageID><Name>SwitchedTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7610</LineageID><MappedToExistingDimensionLineageID>7478</MappedToExistingDimensionLineageID><Name>SwitchedAwardTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7611</LineageID><MappedToExistingDimensionLineageID>7481</MappedToExistingDimensionLineageID><Name>SwitchedAwardType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7612</LineageID><MappedToExistingDimensionLineageID>7484</MappedToExistingDimensionLineageID><Name>SwitchedCIPCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7613</LineageID><MappedToExistingDimensionLineageID>7487</MappedToExistingDimensionLineageID><Name>SwitchedCIP</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
AgeAtProgramRetentionCohort
7531
7460
AgeRangeAtProgramRetentionCohort
7532
7463
AwardType
5730
5666
AwardTypeCode
5729
5663
CIP
7530
7457
CIPCode
7529
7454
CohortTerm
6989
6936
CohortTermTitle
6990
6939
Program
5719
5633
ProgramAdmitStatus
6991
6942
ProgramCode
5718
5630
ProgramRetentionCohortAK
7528
7451
ProgramRetentionCohortSK
7527
7448
RowEndDate
4156
3954
RowIsCurrent
4154
3948
RowStartDate
4155
3951
StudentId
5715
5621
SwitchedAwardType
7538
7481
SwitchedAwardTypeCode
7537
7478
SwitchedCIP
7540
7487
SwitchedCIPCode
7539
7484
SwitchedProgram
7534
7469
SwitchedProgramCode
7533
7466
SwitchedTerm
7535
7472
SwitchedTermTitle
7536
7475
AgeAtProgramRetentionCohort
7544
7418
AgeRangeAtProgramRetentionCohort
7545
7421
AwardType
5762
5495
AwardTypeCode
5761
5492
CIP
7543
7415
CIPCode
7542
7412
CohortTerm
6995
6957
CohortTermTitle
6996
6960
Program
5751
5462
ProgramAdmitStatus
6997
6963
ProgramCode
5750
5459
ProgramRetentionCohortAK
7541
7409
StudentId
5747
5450
SwitchedAwardType
7551
7439
SwitchedAwardTypeCode
7550
7436
SwitchedCIP
7553
7445
SwitchedCIPCode
7552
7442
SwitchedProgram
7547
7427
SwitchedProgramCode
7546
7424
SwitchedTerm
7548
7430
SwitchedTermTitle
7549
7433
  Output Columns
Name ID LineageID
AgeAtProgramRetentionCohort
7574
7574
AgeRangeAtProgramRetentionCohort
7575
7575
AwardType
5828
5828
AwardTypeCode
5827
5827
CIP
7573
7573
CIPCode
7572
7572
CohortTerm
7011
7011
CohortTermTitle
7012
7012
Program
5817
5817
ProgramAdmitStatus
7013
7013
ProgramCode
5816
5816
ProgramRetentionCohortAK
7571
7571
RowEndDate
4264
4264
RowIsCurrent
4262
4262
RowStartDate
4263
4263
StudentId
5813
5813
SwitchedAwardType
7581
7581
SwitchedAwardTypeCode
7580
7580
SwitchedCIP
7583
7583
SwitchedCIPCode
7582
7582
SwitchedProgram
7577
7577
SwitchedProgramCode
7576
7576
SwitchedTerm
7578
7578
SwitchedTermTitle
7579
7579
AgeAtProgramRetentionCohort
7604
7604
AgeRangeAtProgramRetentionCohort
7605
7605
AwardType
5894
5894
AwardTypeCode
5893
5893
CIP
7603
7603
CIPCode
7602
7602
CohortTerm
7027
7027
CohortTermTitle
7028
7028
Program
5883
5883
ProgramAdmitStatus
7029
7029
ProgramCode
5882
5882
ProgramRetentionCohortAK
7601
7601
ProgramRetentionCohortSK
7600
7600
StudentId
5879
5879
SwitchedAwardType
7611
7611
SwitchedAwardTypeCode
7610
7610
SwitchedCIP
7613
7613
SwitchedCIPCode
7612
7612
SwitchedProgram
7607
7607
SwitchedProgramCode
7606
7606
SwitchedTerm
7608
7608
SwitchedTermTitle
7609
7609
Powered by BI Documenter