Variable - SCD1UpdateDimEmployee

Property	Value
Name	SCD1UpdateDimEmployee
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimEmployee] SET EmployeeAK = SCD1.EmployeeAK ,PersonID = SCD1.PersonID ,EmployeeTypeCode = SCD1.EmployeeTypeCode ,EmployeeType = SCD1.EmployeeType ,FullName = SCD1.FullName ,LastName = SCD1.LastName ,FirstName = SCD1.FirstName ,MiddleInitial = SCD1.MiddleInitial ,GenderCode = SCD1.GenderCode ,Gender = SCD1.Gender ,EthnicityCode = SCD1.EthnicityCode ,Ethnicity = SCD1.Ethnicity ,StateCode = SCD1.StateCode ,State = SCD1.State ,ZipCode = SCD1.ZipCode ,CountyFIPSCode = SCD1.CountyFIPSCode ,County = SCD1.County ,CountryCode = SCD1.CountryCode ,Country = SCD1.Country ,CitizenshipCode = SCD1.CitizenshipCode ,Citizenship = SCD1.Citizenship ,CountryOfCitizenshipCode = SCD1.CountryOfCitizenshipCode ,CountryOfCitizens / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimEmployee] SET EmployeeAK = SCD1.EmployeeAK ,PersonID = SCD1.PersonID ,EmployeeTypeCode = SCD1.EmployeeTypeCode ,EmployeeType = SCD1.EmployeeType ,FullName = SCD1.FullName ,LastName = SCD1.LastName ,FirstName = SCD1.FirstName ,MiddleInitial = SCD1.MiddleInitial ,GenderCode = SCD1.GenderCode ,Gender = SCD1.Gender ,EthnicityCode = SCD1.EthnicityCode ,Ethnicity = SCD1.Ethnicity ,StateCode = SCD1.StateCode ,State = SCD1.State ,ZipCode = SCD1.ZipCode ,CountyFIPSCode = SCD1.CountyFIPSCode ,County = SCD1.County ,CountryCode = SCD1.CountryCode ,Country = SCD1.Country ,CitizenshipCode = SCD1.CitizenshipCode ,Citizenship = SCD1.Citizenship ,CountryOfCitizenshipCode = SCD1.CountryOfCitizenshipCode ,CountryOfCitizenship = SCD1.CountryOfCitizenship ,HasActiveAssignment = SCD1.HasActiveAssignment ,NumberOfActiveAssignments = SCD1.NumberOfActiveAssignments ,LastActiveAssignmentDateRange = SCD1.LastActiveAssignmentDateRange ,LastPayCheckDateRange = SCD1.LastPayCheckDateRange ,PositionTypeCode = SCD1.PositionTypeCode ,PositionType = SCD1.PositionType ,FunctionCode = SCD1.FunctionCode ,FunctionDesc = SCD1.FunctionDesc ,LocationCode = SCD1.LocationCode ,Location = SCD1.Location ,PrimarySalaryAccountNumber = SCD1.PrimarySalaryAccountNumber ,IsAStudent = SCD1.IsAStudent ,EmployeeStudentId = SCD1.EmployeeStudentId ,HasDirectDeposit = SCD1.HasDirectDeposit ,HireDate = SCD1.HireDate ,EmployeeFulltimeParttime = SCD1.EmployeeFulltimeParttime ,TerminationDate = SCD1.TerminationDate ,TerminationDateRange = SCD1.TerminationDateRange ,YearsOfServiceToInstitution = SCD1.YearsOfServiceToInstitution ,DateOfBirth = SCD1.DateOfBirth FROM [EnterpriseDW].[dbo].[DimEmployee] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimEmployee__Type1Update] AS SCD1 ON Dim.EmployeeAK = SCD1.EmployeeAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimEmployee dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimEmployee
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimEmployee] SET EmployeeAK = SCD1.EmployeeAK ,PersonID = SCD1.PersonID ,EmployeeTypeCode = SCD1.EmployeeTypeCode ,EmployeeType = SCD1.EmployeeType ,FullName = SCD1.FullName ,LastName = SCD1.LastName ,FirstName = SCD1.FirstName ,MiddleInitial = SCD1.MiddleInitial ,GenderCode = SCD1.GenderCode ,Gender = SCD1.Gender ,EthnicityCode = SCD1.EthnicityCode ,Ethnicity = SCD1.Ethnicity ,StateCode = SCD1.StateCode ,State = SCD1.State ,ZipCode = SCD1.ZipCode ,CountyFIPSCode = SCD1.CountyFIPSCode ,County = SCD1.County ,CountryCode = SCD1.CountryCode ,Country = SCD1.Country ,CitizenshipCode = SCD1.CitizenshipCode ,Citizenship = SCD1.Citizenship ,CountryOfCitizenshipCode = SCD1.CountryOfCitizenshipCode ,CountryOfCitizens
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False