DimStudentSuccessCohortLoad
 SCD1UpdateDimStudentSuccessCohort (Variable)
Home  Diagrams  Documents  Images  DimStudentSuccessCohortLoad  Executables  Connection Managers  Log Providers  Variables 
Current Path:  DimStudentSuccessCohortLoad   Variables   SCD1UpdateDimStudentSuccessCohort
  Properties
Property Value
Name SCD1UpdateDimStudentSuccessCohort
Value Expression: " /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentSuccessCohort] SET StudentSuccessCohortAK = SCD1.StudentSuccessCohortAK, StudentId = SCD1.StudentId, CohortTerm = SCD1.CohortTerm, CohortTermTitle = SCD1.CohortTermTitle, FirstYearTerm = SCD1.FirstYearTerm, LastTermCaptured = SCD1.LastTermCaptured, LastTermCapturedTitle = SCD1.LastTermCapturedTitle, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, ProgramAdmitStatus = SCD1.ProgramAdmitStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, InitialPrepStatus = SCD1.InitialPrepStatus, FirstTerm_FT_PT = SCD1.FirstTerm_FT_PT FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentSuccessCohort] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimStudentSuccessCohort__Type1Update] AS SCD1 ON Dim.Stu

/* Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimStudentSuccessCohort] SET StudentSuccessCohortAK = SCD1.StudentSuccessCohortAK, StudentId = SCD1.StudentId, CohortTerm = SCD1.CohortTerm, CohortTermTitle = SCD1.CohortTermTitle, FirstYearTerm = SCD1.FirstYearTerm, LastTermCaptured = SCD1.LastTermCaptured, LastTermCapturedTitle = SCD1.LastTermCapturedTitle, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, ProgramAdmitStatus = SCD1.ProgramAdmitStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, InitialPrepStatus = SCD1.InitialPrepStatus, FirstTerm_FT_PT = SCD1.FirstTerm_FT_PT FROM [EnterpriseDW].[dbo].[DimStudentSuccessCohort] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimStudentSuccessCohort__Type1Update] AS SCD1 ON Dim.StudentSuccessCohortAK = SCD1.StudentSuccessCohortAK
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::SCD1UpdateDimStudentSuccessCohort
Evaluate As Expression True
Expression " /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentSuccessCohort] SET StudentSuccessCohortAK = SCD1.StudentSuccessCohortAK, StudentId = SCD1.StudentId, CohortTerm = SCD1.CohortTerm, CohortTermTitle = SCD1.CohortTermTitle, FirstYearTerm = SCD1.FirstYearTerm, LastTermCaptured = SCD1.LastTermCaptured, LastTermCapturedTitle = SCD1.LastTermCapturedTitle, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, ProgramAdmitStatus = SCD1.ProgramAdmitStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, InitialPrepStatus = SCD1.InitialPrepStatus, FirstTerm_FT_PT = SCD1.FirstTerm_FT_PT FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentSuccessCohort] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimStudentSuccessCohort__Type1Update] AS SCD1 ON Dim.Stu
ID d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event False
Powered by BI Documenter