Variable - SCD1UpdateDimPosition

Property	Value
Name	SCD1UpdateDimPosition
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPosition] SET PositionAK = SCD1.PositionAK ,PositionCode = SCD1.PositionCode ,PositionTitle = SCD1.PositionTitle ,PositionStatus = SCD1.PositionStatus ,PositionTypeCode = SCD1.PositionTypeCode ,PositionType = SCD1.PositionType ,FunctionCode = SCD1.FunctionCode ,FunctionDescription = SCD1.FunctionDescription ,LocationCode = SCD1.LocationCode ,Location = SCD1.Location ,DateEstablished = SCD1.DateEstablished ,DateInactivated = SCD1.DateInactivated ,JobGroupCode = SCD1.JobGroupCode ,JobGroup = SCD1.JobGroup ,JobClassCode = SCD1.JobClassCode ,PayBasis = SCD1.PayBasis ,Budgeted = SCD1.Budgeted ,RegularTemporary = SCD1.RegularTemporary ,PooledIndicator = SCD1.PooledIndicator ,ExemptStatus = SCD1.ExemptStatus ,PositionFullt / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimPosition] SET PositionAK = SCD1.PositionAK ,PositionCode = SCD1.PositionCode ,PositionTitle = SCD1.PositionTitle ,PositionStatus = SCD1.PositionStatus ,PositionTypeCode = SCD1.PositionTypeCode ,PositionType = SCD1.PositionType ,FunctionCode = SCD1.FunctionCode ,FunctionDescription = SCD1.FunctionDescription ,LocationCode = SCD1.LocationCode ,Location = SCD1.Location ,DateEstablished = SCD1.DateEstablished ,DateInactivated = SCD1.DateInactivated ,JobGroupCode = SCD1.JobGroupCode ,JobGroup = SCD1.JobGroup ,JobClassCode = SCD1.JobClassCode ,PayBasis = SCD1.PayBasis ,Budgeted = SCD1.Budgeted ,RegularTemporary = SCD1.RegularTemporary ,PooledIndicator = SCD1.PooledIndicator ,ExemptStatus = SCD1.ExemptStatus ,PositionFulltimeParttime = SCD1.PositionFulltimeParttime ,PrimarySalaryAccountNumber = SCD1.PrimarySalaryAccountNumber ,CountOfActiveAssignments = SCD1.CountOfActiveAssignments ,CountOfInactiveAssignments = SCD1.CountOfInactiveAssignments ,InactiveReasonCode = SCD1.InactiveReasonCode ,InactiveReason = SCD1.InactiveReason ,InactiveVacantDateRange = SCD1.InactiveVacantDateRange ,FulltimeEquivalent = SCD1.FulltimeEquivalent ,WeeklyAuthorizedHours = SCD1.WeeklyAuthorizedHours ,MultipleFunds = SCD1.MultipleFunds FROM [EnterpriseDW].[dbo].[DimPosition] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimPosition__Type1Update] AS SCD1 ON Dim.PositionAK = SCD1.PositionAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimPosition dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimPosition
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPosition] SET PositionAK = SCD1.PositionAK ,PositionCode = SCD1.PositionCode ,PositionTitle = SCD1.PositionTitle ,PositionStatus = SCD1.PositionStatus ,PositionTypeCode = SCD1.PositionTypeCode ,PositionType = SCD1.PositionType ,FunctionCode = SCD1.FunctionCode ,FunctionDescription = SCD1.FunctionDescription ,LocationCode = SCD1.LocationCode ,Location = SCD1.Location ,DateEstablished = SCD1.DateEstablished ,DateInactivated = SCD1.DateInactivated ,JobGroupCode = SCD1.JobGroupCode ,JobGroup = SCD1.JobGroup ,JobClassCode = SCD1.JobClassCode ,PayBasis = SCD1.PayBasis ,Budgeted = SCD1.Budgeted ,RegularTemporary = SCD1.RegularTemporary ,PooledIndicator = SCD1.PooledIndicator ,ExemptStatus = SCD1.ExemptStatus ,PositionFullt
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False