Variable - SCD1UpdateDimStudent

Property	Value
Name	SCD1UpdateDimStudent
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudent] SET StudentIdAK = SCD1.StudentIdAK ,StudentId = SCD1.StudentId ,FullName = SCD1.FullName ,LastName = SCD1.LastName ,FirstName = SCD1.FirstName ,MiddleName = SCD1.MiddleName ,GenderCode = SCD1.GenderCode ,Gender = SCD1.Gender ,EthnicityCode = SCD1.EthnicityCode ,Ethnicity = SCD1.Ethnicity ,FirstTimeInCollege = SCD1.FirstTimeInCollege ,PrimaryLanguageCode = SCD1.PrimaryLanguageCode ,PrimaryLanguage = SCD1.PrimaryLanguage ,HighSchoolInstitutionId = SCD1.HighSchoolInstitutionId ,HighSchool = SCD1.HighSchool ,HomePhoneNumber = SCD1.HomePhoneNumber ,CellPhoneNumber = SCD1.CellPhoneNumber ,InstitutionalEmailAddress = SCD1.InstitutionalEmailAddres / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimStudent] SET StudentIdAK = SCD1.StudentIdAK ,StudentId = SCD1.StudentId ,FullName = SCD1.FullName ,LastName = SCD1.LastName ,FirstName = SCD1.FirstName ,MiddleName = SCD1.MiddleName ,GenderCode = SCD1.GenderCode ,Gender = SCD1.Gender ,EthnicityCode = SCD1.EthnicityCode ,Ethnicity = SCD1.Ethnicity ,FirstTimeInCollege = SCD1.FirstTimeInCollege ,PrimaryLanguageCode = SCD1.PrimaryLanguageCode ,PrimaryLanguage = SCD1.PrimaryLanguage ,HighSchoolInstitutionId = SCD1.HighSchoolInstitutionId ,HighSchool = SCD1.HighSchool ,HomePhoneNumber = SCD1.HomePhoneNumber ,CellPhoneNumber = SCD1.CellPhoneNumber ,InstitutionalEmailAddress = SCD1.InstitutionalEmailAddress ,PersonalEmailAddress = SCD1.PersonalEmailAddress ,ImmigrationStatusCode = SCD1.ImmigrationStatusCode ,ImmigrationStatus = SCD1.ImmigrationStatus ,ResidencyCode = SCD1.ResidencyCode ,Residency = SCD1.Residency ,ResidencyCountyCode = SCD1.ResidencyCountyCode ,ResidencyCounty = SCD1.ResidencyCounty ,ResidencyStateCode = SCD1.ResidencyStateCode ,ResidencyState = SCD1.ResidencyState ,ZipCode = SCD1.ZipCode ,DateOfBirth = SCD1.DateOfBirth ,FERPARequested = SCD1.FERPARequested ,RaceWhite = SCD1.RaceWhite ,RaceAfricanAmerican = SCD1.RaceAfricanAmerican ,RacePacificIslander = SCD1.RacePacificIslander ,RaceAsian = SCD1.RaceAsian ,RaceAmericanIndian = SCD1.RaceAmericanIndian ,RaceUnreported = SCD1.RaceUnreported ,CountryOfBirthCode = SCD1.CountryOfBirthCode ,CountryOfBirth = SCD1.CountryOfBirth ,CountryOfCitizenshipCode = SCD1.CountryOfCitizenshipCode ,CountryOfCitizenship = SCD1.CountryOfCitizenship ,HomeCampusCode = SCD1.HomeCampusCode ,HomeCampus = SCD1.HomeCampus ,InitialPrepStatus = SCD1.InitialPrepStatus ,VeteranStudent = SCD1.VeteranStudent ,StudentAthlete = SCD1.StudentAthlete ,InternationalStudent = SCD1.InternationalStudent FROM [EnterpriseDW].[dbo].[DimStudent] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimStudent__Type1Update] AS SCD1 ON Dim.StudentIdAK = SCD1.StudentIdAK
Value Type	String
Description	The SQL Statement that will update the rows in the DimStudent Table.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimStudent
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudent] SET StudentIdAK = SCD1.StudentIdAK ,StudentId = SCD1.StudentId ,FullName = SCD1.FullName ,LastName = SCD1.LastName ,FirstName = SCD1.FirstName ,MiddleName = SCD1.MiddleName ,GenderCode = SCD1.GenderCode ,Gender = SCD1.Gender ,EthnicityCode = SCD1.EthnicityCode ,Ethnicity = SCD1.Ethnicity ,FirstTimeInCollege = SCD1.FirstTimeInCollege ,PrimaryLanguageCode = SCD1.PrimaryLanguageCode ,PrimaryLanguage = SCD1.PrimaryLanguage ,HighSchoolInstitutionId = SCD1.HighSchoolInstitutionId ,HighSchool = SCD1.HighSchool ,HomePhoneNumber = SCD1.HomePhoneNumber ,CellPhoneNumber = SCD1.CellPhoneNumber ,InstitutionalEmailAddress = SCD1.InstitutionalEmailAddres
ID	7a6cc9fc-8240-4c11-9ae8-f336e69e11f8
Raise Changed Event	False