Variable - SCD1UpdateDimApplication

Property	Value
Name	SCD1UpdateDimApplication
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimApplication] SET ApplicationAK = SCD1.ApplicationAK ,StudentId = SCD1.StudentId ,ApplicationTerm = SCD1.ApplicationTerm ,ApplicationTermTitle = SCD1.ApplicationTermTitle ,ApplicationEntry = SCD1.ApplicationEntry ,ApplicationTypeCode = SCD1.ApplicationTypeCode ,ApplicationType = SCD1.ApplicationType ,CreditVocationalBachelorApplication = SCD1.CreditVocationalBachelorApplication ,InitialOrReadmitApplication = SCD1.InitialOrReadmitApplication ,BasisOfAdmissionCode = SCD1.BasisOfAdmissionCode ,BasisOfAdmission = SCD1.BasisOfAdmission ,EnrollmentStatusCode = SCD1.EnrollmentStatusCode ,EnrollmentStatus = SCD1.EnrollmentStatus ,FirstTimeInCollege = SCD1.FirstTimeInCollege ,BachelorApplic / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimApplication] SET ApplicationAK = SCD1.ApplicationAK ,StudentId = SCD1.StudentId ,ApplicationTerm = SCD1.ApplicationTerm ,ApplicationTermTitle = SCD1.ApplicationTermTitle ,ApplicationEntry = SCD1.ApplicationEntry ,ApplicationTypeCode = SCD1.ApplicationTypeCode ,ApplicationType = SCD1.ApplicationType ,CreditVocationalBachelorApplication = SCD1.CreditVocationalBachelorApplication ,InitialOrReadmitApplication = SCD1.InitialOrReadmitApplication ,BasisOfAdmissionCode = SCD1.BasisOfAdmissionCode ,BasisOfAdmission = SCD1.BasisOfAdmission ,EnrollmentStatusCode = SCD1.EnrollmentStatusCode ,EnrollmentStatus = SCD1.EnrollmentStatus ,FirstTimeInCollege = SCD1.FirstTimeInCollege ,BachelorApplicant = SCD1.BachelorApplicant ,ProgramCode = SCD1.ProgramCode ,Program = SCD1.Program ,AwardTypeCode = SCD1.AwardTypeCode ,AwardType = SCD1.AwardType ,ApplicationDate = SCD1.ApplicationDate ,FirstTermEnrolled = SCD1.FirstTermEnrolled ,FirstTermEnrolledTitle = SCD1.FirstTermEnrolledTitle ,HomeCampusCode = SCD1.HomeCampusCode ,HomeCampus = SCD1.HomeCampus FROM [EnterpriseDW].[dbo].[DimApplication] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimApplication__Type1Update] AS SCD1 ON Dim.ApplicationAK = SCD1.ApplicationAK
Value Type	String
Description	The SQL Statement that will update the rows in the DimStudent Table.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimApplication
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimApplication] SET ApplicationAK = SCD1.ApplicationAK ,StudentId = SCD1.StudentId ,ApplicationTerm = SCD1.ApplicationTerm ,ApplicationTermTitle = SCD1.ApplicationTermTitle ,ApplicationEntry = SCD1.ApplicationEntry ,ApplicationTypeCode = SCD1.ApplicationTypeCode ,ApplicationType = SCD1.ApplicationType ,CreditVocationalBachelorApplication = SCD1.CreditVocationalBachelorApplication ,InitialOrReadmitApplication = SCD1.InitialOrReadmitApplication ,BasisOfAdmissionCode = SCD1.BasisOfAdmissionCode ,BasisOfAdmission = SCD1.BasisOfAdmission ,EnrollmentStatusCode = SCD1.EnrollmentStatusCode ,EnrollmentStatus = SCD1.EnrollmentStatus ,FirstTimeInCollege = SCD1.FirstTimeInCollege ,BachelorApplic
ID	25c13b34-ebbd-44cd-a50f-ccd24d05827d
Raise Changed Event	False