Variable - SCD1UpdateDimAssignment

Property	Value
Name	SCD1UpdateDimAssignment
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimAssignment] SET AssignmentAK = SCD1.AssignmentAK ,PersonId = SCD1.PersonId ,PositionCode = SCD1.PositionCode ,AssignmentSequenceNumber = SCD1.AssignmentSequenceNumber ,JobTitle = SCD1.JobTitle ,AssignmentStatus = SCD1.AssignmentStatus ,AssignmentTypeCode = SCD1.AssignmentTypeCode ,AssignmentType = SCD1.AssignmentType ,FunctionCode = SCD1.FunctionCode ,FunctionDesc = SCD1.FunctionDesc ,PrimarySalaryAccountNumber = SCD1.PrimarySalaryAccountNumber ,StartDate = SCD1.StartDate ,EndDate = SCD1.EndDate ,JobGroupCode = SCD1.JobGroupCode ,JobGroup = SCD1.JobGroup ,JobClassCode = SCD1.JobClassCode ,PayBasis = SCD1.PayBasis ,InstitutionalAssignmentTypeCode = SCD1.InstitutionalAssignmentTypeCode ,InstitutionalAssignmentType = SCD1.Institut / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimAssignment] SET AssignmentAK = SCD1.AssignmentAK ,PersonId = SCD1.PersonId ,PositionCode = SCD1.PositionCode ,AssignmentSequenceNumber = SCD1.AssignmentSequenceNumber ,JobTitle = SCD1.JobTitle ,AssignmentStatus = SCD1.AssignmentStatus ,AssignmentTypeCode = SCD1.AssignmentTypeCode ,AssignmentType = SCD1.AssignmentType ,FunctionCode = SCD1.FunctionCode ,FunctionDesc = SCD1.FunctionDesc ,PrimarySalaryAccountNumber = SCD1.PrimarySalaryAccountNumber ,StartDate = SCD1.StartDate ,EndDate = SCD1.EndDate ,JobGroupCode = SCD1.JobGroupCode ,JobGroup = SCD1.JobGroup ,JobClassCode = SCD1.JobClassCode ,PayBasis = SCD1.PayBasis ,InstitutionalAssignmentTypeCode = SCD1.InstitutionalAssignmentTypeCode ,InstitutionalAssignmentType = SCD1.InstitutionalAssignmentType ,PrimaryAssignment = SCD1.PrimaryAssignment ,RegularTemporary = SCD1.RegularTemporary ,ExemptStatus = SCD1.ExemptStatus ,AssignmentFulltimeParttime = SCD1.AssignmentFulltimeParttime ,AssignmentEndDateRange = SCD1.AssignmentEndDateRange ,LastPaymentDateRange = SCD1.LastPaymentDateRange ,EndBasisCode = SCD1.EndBasisCode ,EndBasis = SCD1.EndBasis ,BaseSalary = SCD1.BaseSalary ,ActualSalary = SCD1.ActualSalary ,DailyRate = SCD1.DailyRate ,HourlyRate = SCD1.HourlyRate ,OvertimeRate = SCD1.OvertimeRate ,TotalSalary = SCD1.TotalSalary FROM [EnterpriseDW].[dbo].[DimAssignment] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimAssignment__Type1Update] AS SCD1 ON Dim.AssignmentAK = SCD1.AssignmentAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimAssignment dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimAssignment
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimAssignment] SET AssignmentAK = SCD1.AssignmentAK ,PersonId = SCD1.PersonId ,PositionCode = SCD1.PositionCode ,AssignmentSequenceNumber = SCD1.AssignmentSequenceNumber ,JobTitle = SCD1.JobTitle ,AssignmentStatus = SCD1.AssignmentStatus ,AssignmentTypeCode = SCD1.AssignmentTypeCode ,AssignmentType = SCD1.AssignmentType ,FunctionCode = SCD1.FunctionCode ,FunctionDesc = SCD1.FunctionDesc ,PrimarySalaryAccountNumber = SCD1.PrimarySalaryAccountNumber ,StartDate = SCD1.StartDate ,EndDate = SCD1.EndDate ,JobGroupCode = SCD1.JobGroupCode ,JobGroup = SCD1.JobGroup ,JobClassCode = SCD1.JobClassCode ,PayBasis = SCD1.PayBasis ,InstitutionalAssignmentTypeCode = SCD1.InstitutionalAssignmentTypeCode ,InstitutionalAssignmentType = SCD1.Institut
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False