Variable - SCD1UpdateDimStudentTerm

Property	Value
Name	SCD1UpdateDimStudentTerm
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentTerm] SET StudentTermAK = SCD1.StudentTermAK ,StudentId = SCD1.StudentId ,Term = SCD1.Term ,TermTitle = SCD1.TermTitle ,ResidencyCode = SCD1.ResidencyCode ,Residency = SCD1.Residency ,ProgramCode = SCD1.ProgramCode ,Program = SCD1.Program ,ProgramAdmitStatus = SCD1.ProgramAdmitStatus ,AcademicStatusCode = SCD1.AcademicStatusCode ,AcademicStatus = SCD1.AcademicStatus ,BasisOfAdmissionCode = SCD1.BasisOfAdmissionCode ,BasisOfAdmission = SCD1.BasisOfAdmission ,EnrollmentStatusCode = SCD1.EnrollmentStatusCode ,EnrollmentStatus = SCD1.EnrollmentStatus ,AgeAtTerm = SCD1.AgeAtTerm ,AgeRangeAtTerm = SCD1.AgeRangeAtTerm ,AwardTypeCode = SCD1.A / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimStudentTerm] SET StudentTermAK = SCD1.StudentTermAK ,StudentId = SCD1.StudentId ,Term = SCD1.Term ,TermTitle = SCD1.TermTitle ,ResidencyCode = SCD1.ResidencyCode ,Residency = SCD1.Residency ,ProgramCode = SCD1.ProgramCode ,Program = SCD1.Program ,ProgramAdmitStatus = SCD1.ProgramAdmitStatus ,AcademicStatusCode = SCD1.AcademicStatusCode ,AcademicStatus = SCD1.AcademicStatus ,BasisOfAdmissionCode = SCD1.BasisOfAdmissionCode ,BasisOfAdmission = SCD1.BasisOfAdmission ,EnrollmentStatusCode = SCD1.EnrollmentStatusCode ,EnrollmentStatus = SCD1.EnrollmentStatus ,AgeAtTerm = SCD1.AgeAtTerm ,AgeRangeAtTerm = SCD1.AgeRangeAtTerm ,AwardTypeCode = SCD1.AwardTypeCode ,AwardType = SCD1.AwardType ,SdbAwardTypeCode = SCD1.SdbAwardTypeCode ,Advised = SCD1.Advised ,AdvisementStatusCode = SCD1.AdvisementStatusCode ,AdvisementStatus = SCD1.AdvisementStatus ,AdvisementMandatory = SCD1.AdvisementMandatory ,DateLastAdvised = SCD1.DateLastAdvised ,AdvisementProgramCode = SCD1.AdvisementProgramCode ,AdvisementProgram = SCD1.AdvisementProgram ,AdvisementAwardTypeCode = SCD1.AdvisementAwardTypeCode ,AdvisementAwardType = SCD1.AdvisementAwardType ,AdvisementAdvisorId = SCD1.AdvisementAdvisorId ,AdvisementAdvisor = SCD1.AdvisementAdvisor ,TransferMajorAdvisementCode = SCD1.TransferMajorAdvisementCode ,TransferMajorAdvisement = SCD1.TransferMajorAdvisement ,TransferInstitutionAdvisementId = SCD1.TransferInstitutionAdvisementId ,TransferInstitutionAdvisement = SCD1.TransferInstitutionAdvisement FROM [EnterpriseDW].[dbo].[DimStudentTerm] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimStudentTerm__Type1Update] AS SCD1 ON Dim.StudentTermAK = SCD1.StudentTermAK
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::SCD1UpdateDimStudentTerm
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentTerm] SET StudentTermAK = SCD1.StudentTermAK ,StudentId = SCD1.StudentId ,Term = SCD1.Term ,TermTitle = SCD1.TermTitle ,ResidencyCode = SCD1.ResidencyCode ,Residency = SCD1.Residency ,ProgramCode = SCD1.ProgramCode ,Program = SCD1.Program ,ProgramAdmitStatus = SCD1.ProgramAdmitStatus ,AcademicStatusCode = SCD1.AcademicStatusCode ,AcademicStatus = SCD1.AcademicStatus ,BasisOfAdmissionCode = SCD1.BasisOfAdmissionCode ,BasisOfAdmission = SCD1.BasisOfAdmission ,EnrollmentStatusCode = SCD1.EnrollmentStatusCode ,EnrollmentStatus = SCD1.EnrollmentStatus ,AgeAtTerm = SCD1.AgeAtTerm ,AgeRangeAtTerm = SCD1.AgeRangeAtTerm ,AwardTypeCode = SCD1.A
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False