Variable - SCD1UpdateDimGlCode

Property	Value
Name	SCD1UpdateDimGlCode
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimGlCode] SET GlCodeAK = SCD1.GlCodeAK ,Glc = SCD1.Glc ,Qual2 = SCD1.Qual2 ,GlClassCode = SCD1.GlClassCode ,GlClass = SCD1.GlClass ,GlGroup = SCD1.GlGroup ,GlCategoryCode = SCD1.GlCategoryCode ,GlCategory = SCD1.GlCategory ,GlSubCategoryCode = SCD1.GlSubCategoryCode ,GlSubCategory = SCD1.GlSubCategory ,GlcDescription = SCD1.GlcDescription ,GlCodeName = SCD1.GlCodeName ,GlCodeSubTotalCode = SCD1.GlCodeSubTotalCode ,GlCodeSubTotal = SCD1.GlCodeSubTotal ,HrClassification = SCD1.HrClassification ,HrTimeStatus = SCD1.HrTimeStatus ,AccountSign = SCD1.AccountSign FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimGlCode] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimG / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimGlCode] SET GlCodeAK = SCD1.GlCodeAK ,Glc = SCD1.Glc ,Qual2 = SCD1.Qual2 ,GlClassCode = SCD1.GlClassCode ,GlClass = SCD1.GlClass ,GlGroup = SCD1.GlGroup ,GlCategoryCode = SCD1.GlCategoryCode ,GlCategory = SCD1.GlCategory ,GlSubCategoryCode = SCD1.GlSubCategoryCode ,GlSubCategory = SCD1.GlSubCategory ,GlcDescription = SCD1.GlcDescription ,GlCodeName = SCD1.GlCodeName ,GlCodeSubTotalCode = SCD1.GlCodeSubTotalCode ,GlCodeSubTotal = SCD1.GlCodeSubTotal ,HrClassification = SCD1.HrClassification ,HrTimeStatus = SCD1.HrTimeStatus ,AccountSign = SCD1.AccountSign FROM [EnterpriseDW].[dbo].[DimGlCode] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimGlCode__Type1Update] AS SCD1 ON Dim.GlCodeAK = SCD1.GlCodeAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimGlCode dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimGlCode
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimGlCode] SET GlCodeAK = SCD1.GlCodeAK ,Glc = SCD1.Glc ,Qual2 = SCD1.Qual2 ,GlClassCode = SCD1.GlClassCode ,GlClass = SCD1.GlClass ,GlGroup = SCD1.GlGroup ,GlCategoryCode = SCD1.GlCategoryCode ,GlCategory = SCD1.GlCategory ,GlSubCategoryCode = SCD1.GlSubCategoryCode ,GlSubCategory = SCD1.GlSubCategory ,GlcDescription = SCD1.GlcDescription ,GlCodeName = SCD1.GlCodeName ,GlCodeSubTotalCode = SCD1.GlCodeSubTotalCode ,GlCodeSubTotal = SCD1.GlCodeSubTotal ,HrClassification = SCD1.HrClassification ,HrTimeStatus = SCD1.HrTimeStatus ,AccountSign = SCD1.AccountSign FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimGlCode] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimG
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False