Variable - SCD1UpdateDimOrgUnit

Property	Value
Name	SCD1UpdateDimOrgUnit
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimOrgUnit] SET [OrgUnitAK] = SCD1.OrgUnitAK ,[OrgUnit] = SCD1.OrgUnit ,[OrgUnitName] = SCD1.OrgUnitName ,[OrgUnitStatusCode] = SCD1.OrgUnitStatusCode ,[OrgUnitStatus] = SCD1.OrgUnitStatus ,[FundCode] = SCD1.FundCode ,[Fund] = SCD1.Fund ,[FunctionCode] = SCD1.FunctionCode ,[FunctionDescription] = SCD1.FunctionDescription ,[SubFunctionCode] = SCD1.SubFunctionCode ,[SubFunction] = SCD1.SubFunction ,[StateOrgUnit] = SCD1.StateOrgUnit ,[LocationCode] = SCD1.LocationCode ,[Location] = SCD1.Location ,[Qual1] = SCD1.Qual1 ,[ControlOrgUnit] = SCD1.ControlOrgUnit ,[ControlOrgUnitName] = SCD1.ControlOrgUnitName ,[BudgetManagerId] = SCD1.BudgetManagerId ,[BudgetManager] = SCD1.BudgetManager ,[UserGroupId] = SCD1.UserGroupId ,[User / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimOrgUnit] SET [OrgUnitAK] = SCD1.OrgUnitAK ,[OrgUnit] = SCD1.OrgUnit ,[OrgUnitName] = SCD1.OrgUnitName ,[OrgUnitStatusCode] = SCD1.OrgUnitStatusCode ,[OrgUnitStatus] = SCD1.OrgUnitStatus ,[FundCode] = SCD1.FundCode ,[Fund] = SCD1.Fund ,[FunctionCode] = SCD1.FunctionCode ,[FunctionDescription] = SCD1.FunctionDescription ,[SubFunctionCode] = SCD1.SubFunctionCode ,[SubFunction] = SCD1.SubFunction ,[StateOrgUnit] = SCD1.StateOrgUnit ,[LocationCode] = SCD1.LocationCode ,[Location] = SCD1.Location ,[Qual1] = SCD1.Qual1 ,[ControlOrgUnit] = SCD1.ControlOrgUnit ,[ControlOrgUnitName] = SCD1.ControlOrgUnitName ,[BudgetManagerId] = SCD1.BudgetManagerId ,[BudgetManager] = SCD1.BudgetManager ,[UserGroupId] = SCD1.UserGroupId ,[UserGroup] = SCD1.UserGroup ,[PrincipalAdminId] = SCD1.PrincipalAdminId ,[PrincipalAdmin] = SCD1.PrincipalAdmin ,[ProjectNumber] = SCD1.ProjectNumber ,[ReportDistributionCode] = SCD1.ReportDistributionCode ,[ReportDistribution] = SCD1.ReportDistribution ,[OrgUnitGrouping] = SCD1.OrgUnitGrouping ,[StartDate] = SCD1.StartDate ,[EndDate] = SCD1.EndDate FROM [EnterpriseDW].[dbo].[DimOrgUnit] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimOrgUnit__Type1Update] AS SCD1 ON Dim.OrgUnitAK = SCD1.OrgUnitAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimOrgUnit dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimOrgUnit
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimOrgUnit] SET [OrgUnitAK] = SCD1.OrgUnitAK ,[OrgUnit] = SCD1.OrgUnit ,[OrgUnitName] = SCD1.OrgUnitName ,[OrgUnitStatusCode] = SCD1.OrgUnitStatusCode ,[OrgUnitStatus] = SCD1.OrgUnitStatus ,[FundCode] = SCD1.FundCode ,[Fund] = SCD1.Fund ,[FunctionCode] = SCD1.FunctionCode ,[FunctionDescription] = SCD1.FunctionDescription ,[SubFunctionCode] = SCD1.SubFunctionCode ,[SubFunction] = SCD1.SubFunction ,[StateOrgUnit] = SCD1.StateOrgUnit ,[LocationCode] = SCD1.LocationCode ,[Location] = SCD1.Location ,[Qual1] = SCD1.Qual1 ,[ControlOrgUnit] = SCD1.ControlOrgUnit ,[ControlOrgUnitName] = SCD1.ControlOrgUnitName ,[BudgetManagerId] = SCD1.BudgetManagerId ,[BudgetManager] = SCD1.BudgetManager ,[UserGroupId] = SCD1.UserGroupId ,[User
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False