Variable - SCD1UpdateDimInstitutionalRetentionCohort

Property	Value
Name	SCD1UpdateDimInstitutionalRetentionCohort
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimInstitutionalRetentionCohort] SET InstitutionalRetentionCohortAK = SCD1.InstitutionalRetentionCohortAK, StudentId = SCD1.StudentId, CohortYear = SCD1.CohortYear, CohortTerm = SCD1.CohortTerm, CohortTermTitle = SCD1.CohortTermTitle, FirstTerm_FT_PT = SCD1.FirstTerm_FT_PT, RetentionCohortTypeCode = SCD1.RetentionCohortTypeCode, RetentionCohortType = SCD1.RetentionCohortType, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, ProgramAdmitStatus = SCD1.ProgramAdmitStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, AgeAtInstitutionalRetentionCohort = SCD1.AgeAtInstitutionalRetentionCohort, AgeRangeAtInstitutionalRetentionCohort = SCD1.AgeRangeAtInstitutionalRetentionCohort FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "]. / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimInstitutionalRetentionCohort] SET InstitutionalRetentionCohortAK = SCD1.InstitutionalRetentionCohortAK, StudentId = SCD1.StudentId, CohortYear = SCD1.CohortYear, CohortTerm = SCD1.CohortTerm, CohortTermTitle = SCD1.CohortTermTitle, FirstTerm_FT_PT = SCD1.FirstTerm_FT_PT, RetentionCohortTypeCode = SCD1.RetentionCohortTypeCode, RetentionCohortType = SCD1.RetentionCohortType, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, ProgramAdmitStatus = SCD1.ProgramAdmitStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, AgeAtInstitutionalRetentionCohort = SCD1.AgeAtInstitutionalRetentionCohort, AgeRangeAtInstitutionalRetentionCohort = SCD1.AgeRangeAtInstitutionalRetentionCohort FROM [EnterpriseDW].[dbo].[DimInstitutionalRetentionCohort] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimInstitutionalRetentionCohort__Type1Update] AS SCD1 ON Dim.InstitutionalRetentionCohortAK = SCD1.InstitutionalRetentionCohortAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimStudentTerm dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimInstitutionalRetentionCohort
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimInstitutionalRetentionCohort] SET InstitutionalRetentionCohortAK = SCD1.InstitutionalRetentionCohortAK, StudentId = SCD1.StudentId, CohortYear = SCD1.CohortYear, CohortTerm = SCD1.CohortTerm, CohortTermTitle = SCD1.CohortTermTitle, FirstTerm_FT_PT = SCD1.FirstTerm_FT_PT, RetentionCohortTypeCode = SCD1.RetentionCohortTypeCode, RetentionCohortType = SCD1.RetentionCohortType, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, ProgramAdmitStatus = SCD1.ProgramAdmitStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, AgeAtInstitutionalRetentionCohort = SCD1.AgeAtInstitutionalRetentionCohort, AgeRangeAtInstitutionalRetentionCohort = SCD1.AgeRangeAtInstitutionalRetentionCohort FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False