Variable - SCD1UpdateDimStudentObjective

Property	Value
Name	SCD1UpdateDimStudentObjective
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentObjective] SET StudentObjectiveAK = SCD1.StudentObjectiveAK, StudentId = SCD1.StudentId, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, EffectiveTerm = SCD1.EffectiveTerm, EffectiveTermTitle = SCD1.EffectiveTermTitle, SequenceNumber = SCD1.SequenceNumber, AdmissionStatus = SCD1.AdmissionStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, PrimaryObjective = SCD1.PrimaryObjective, ProgramStatusCode = SCD1.ProgramStatusCode, GraduationStatusCode = SCD1.GraduationStatusCode, ExpectedGraduationTerm = SCD1.ExpectedGraduationTerm, ExpectedGraduationTermTitle = SCD1.ExpectedGraduationTermTitle, ActualGraduationTerm = SCD1.ActualGraduationTerm, ActualGraduationTermTitle = SCD1.ActualGraduationTermTitle, GraduationAge = SCD1.GraduationAge, GraduationAgeRange = SCD1.Graduati / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimStudentObjective] SET StudentObjectiveAK = SCD1.StudentObjectiveAK, StudentId = SCD1.StudentId, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, EffectiveTerm = SCD1.EffectiveTerm, EffectiveTermTitle = SCD1.EffectiveTermTitle, SequenceNumber = SCD1.SequenceNumber, AdmissionStatus = SCD1.AdmissionStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, PrimaryObjective = SCD1.PrimaryObjective, ProgramStatusCode = SCD1.ProgramStatusCode, GraduationStatusCode = SCD1.GraduationStatusCode, ExpectedGraduationTerm = SCD1.ExpectedGraduationTerm, ExpectedGraduationTermTitle = SCD1.ExpectedGraduationTermTitle, ActualGraduationTerm = SCD1.ActualGraduationTerm, ActualGraduationTermTitle = SCD1.ActualGraduationTermTitle, GraduationAge = SCD1.GraduationAge, GraduationAgeRange = SCD1.GraduationAgeRange, GraduationHonorsCode = SCD1.GraduationHonorsCode, TransferMajorCode = SCD1.TransferMajorCode, TransferMajor = SCD1.TransferMajor, TransferInstitutionId = SCD1.TransferInstitutionId, TransferInstitution = SCD1.TransferInstitution, ReportedTerm = SCD1.ReportedTerm, ReportedTermTitle = SCD1.ReportedTermTitle FROM [EnterpriseDW].[dbo].[DimStudentObjective] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimStudentObjective__Type1Update] AS SCD1 ON Dim.StudentObjectiveAK = SCD1.StudentObjectiveAK
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::SCD1UpdateDimStudentObjective
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentObjective] SET StudentObjectiveAK = SCD1.StudentObjectiveAK, StudentId = SCD1.StudentId, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, EffectiveTerm = SCD1.EffectiveTerm, EffectiveTermTitle = SCD1.EffectiveTermTitle, SequenceNumber = SCD1.SequenceNumber, AdmissionStatus = SCD1.AdmissionStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, PrimaryObjective = SCD1.PrimaryObjective, ProgramStatusCode = SCD1.ProgramStatusCode, GraduationStatusCode = SCD1.GraduationStatusCode, ExpectedGraduationTerm = SCD1.ExpectedGraduationTerm, ExpectedGraduationTermTitle = SCD1.ExpectedGraduationTermTitle, ActualGraduationTerm = SCD1.ActualGraduationTerm, ActualGraduationTermTitle = SCD1.ActualGraduationTermTitle, GraduationAge = SCD1.GraduationAge, GraduationAgeRange = SCD1.Graduati
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False