Variable - SCD1UpdateDimTerm

Property	Value
Name	SCD1UpdateDimTerm
Value	Expression: "/* SQL UPDATE DimTerm from Temp Tables / UPDATE Dim SET TermStartDate = SCD1.TermStartDate ,TermEndDate = SCD1.TermEndDate ,TermTitle = SCD1.TermTitle ,AcademicYearCode = SCD1.AcademicYearCode ,AcademicYear = SCD1.AcademicYear ,TermYear = SCD1.TermYear ,TermTypeCode = SCD1.TermTypeCode ,TermType = SCD1.TermType ,ActiveTerm = SCD1.ActiveTerm ,DefaultTerm = SCD1.DefaultTerm ,PriorYearTerm = SCD1.PriorYearTerm ,RelativeDay = SCD1.RelativeDay ,StateReportingTermYear = SCD1.StateReportingTermYear ,StateReportingTermSequence = SCD1.StateReportingTermSequence FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimTerm] as Dim INNER JOIN dbo.Staged_dbo_DimTerm__Type1Update SCD1 ON Dim.TermAK = SCD1.TermAK " / SQL UPDATE DimTerm from Temp Tables */ UPDATE Dim SET TermStartDate = SCD1.TermStartDate ,TermEndDate = SCD1.TermEndDate ,TermTitle = SCD1.TermTitle ,AcademicYearCode = SCD1.AcademicYearCode ,AcademicYear = SCD1.AcademicYear ,TermYear = SCD1.TermYear ,TermTypeCode = SCD1.TermTypeCode ,TermType = SCD1.TermType ,ActiveTerm = SCD1.ActiveTerm ,DefaultTerm = SCD1.DefaultTerm ,PriorYearTerm = SCD1.PriorYearTerm ,RelativeDay = SCD1.RelativeDay ,StateReportingTermYear = SCD1.StateReportingTermYear ,StateReportingTermSequence = SCD1.StateReportingTermSequence FROM [EnterpriseDW].[dbo].[DimTerm] as Dim INNER JOIN dbo.Staged_dbo_DimTerm__Type1Update SCD1 ON Dim.TermAK = SCD1.TermAK
Value Type	String
Description	This variable contains the SQL statement that is used to update the changed rows in the DimTerm table
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimTerm
Evaluate As Expression	True
Expression	"/* SQL UPDATE DimTerm from Temp Tables */ UPDATE Dim SET TermStartDate = SCD1.TermStartDate ,TermEndDate = SCD1.TermEndDate ,TermTitle = SCD1.TermTitle ,AcademicYearCode = SCD1.AcademicYearCode ,AcademicYear = SCD1.AcademicYear ,TermYear = SCD1.TermYear ,TermTypeCode = SCD1.TermTypeCode ,TermType = SCD1.TermType ,ActiveTerm = SCD1.ActiveTerm ,DefaultTerm = SCD1.DefaultTerm ,PriorYearTerm = SCD1.PriorYearTerm ,RelativeDay = SCD1.RelativeDay ,StateReportingTermYear = SCD1.StateReportingTermYear ,StateReportingTermSequence = SCD1.StateReportingTermSequence FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimTerm] as Dim INNER JOIN dbo.Staged_dbo_DimTerm__Type1Update SCD1 ON Dim.TermAK = SCD1.TermAK "
ID	d487061d-385a-445b-891e-85e67723af13
Raise Changed Event	False