Variable - SCD1UpdateDimTimeType

Property	Value
Name	SCD1UpdateDimTimeType
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimTimeType] SET TimeTypeAK = SCD1.TimeTypeAK ,TimeTypeCode = SCD1.TimeTypeCode ,TimeType = SCD1.TimeType ,RegularTime = SCD1.RegularTime ,PaidTime = SCD1.PaidTime ,OvertimeTime = SCD1.OvertimeTime ,LeaveTime = SCD1.LeaveTime ,LongTermTime = SCD1.LongTermTime ,AccruedTime = SCD1.AccruedTime ,EarnedTime = SCD1.EarnedTime ,SickPoolTime = SCD1.SickPoolTime ,TimeAttendReportingOptionCode = SCD1.TimeAttendReportingOptionCode ,TimeAttendReportingOption = SCD1.TimeAttendReportingOption FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimTimeType] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimTimeType__Type1Update] AS SCD1 ON Dim.TimeTypeAK = SCD1.TimeTypeAK " / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimTimeType] SET TimeTypeAK = SCD1.TimeTypeAK ,TimeTypeCode = SCD1.TimeTypeCode ,TimeType = SCD1.TimeType ,RegularTime = SCD1.RegularTime ,PaidTime = SCD1.PaidTime ,OvertimeTime = SCD1.OvertimeTime ,LeaveTime = SCD1.LeaveTime ,LongTermTime = SCD1.LongTermTime ,AccruedTime = SCD1.AccruedTime ,EarnedTime = SCD1.EarnedTime ,SickPoolTime = SCD1.SickPoolTime ,TimeAttendReportingOptionCode = SCD1.TimeAttendReportingOptionCode ,TimeAttendReportingOption = SCD1.TimeAttendReportingOption FROM [EnterpriseDW].[dbo].[DimTimeType] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimTimeType__Type1Update] AS SCD1 ON Dim.TimeTypeAK = SCD1.TimeTypeAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimTimeType dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimTimeType
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimTimeType] SET TimeTypeAK = SCD1.TimeTypeAK ,TimeTypeCode = SCD1.TimeTypeCode ,TimeType = SCD1.TimeType ,RegularTime = SCD1.RegularTime ,PaidTime = SCD1.PaidTime ,OvertimeTime = SCD1.OvertimeTime ,LeaveTime = SCD1.LeaveTime ,LongTermTime = SCD1.LongTermTime ,AccruedTime = SCD1.AccruedTime ,EarnedTime = SCD1.EarnedTime ,SickPoolTime = SCD1.SickPoolTime ,TimeAttendReportingOptionCode = SCD1.TimeAttendReportingOptionCode ,TimeAttendReportingOption = SCD1.TimeAttendReportingOption FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimTimeType] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimTimeType__Type1Update] AS SCD1 ON Dim.TimeTypeAK = SCD1.TimeTypeAK "
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False