Variable - SCD1UpdateDimPurchaseOrder

Property	Value
Name	SCD1UpdateDimPurchaseOrder
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPurchaseOrder] SET PurchaseOrderAK = SCD1.PurchaseOrderAK ,FiscalYear = SCD1.FiscalYear ,PurchaseOrderNumber = SCD1.PurchaseOrderNumber ,PoStatusCode = SCD1.PoStatusCode ,PoStatus = SCD1.PoStatus ,ReceivingStatusCode = SCD1.ReceivingStatusCode ,ReceivingStatus = SCD1.ReceivingStatus ,PayStatusCode = SCD1.PayStatusCode ,PayStatus = SCD1.PayStatus ,PoTypeCode = SCD1.PoTypeCode ,PoType = SCD1.PoType ,BuyerId = SCD1.BuyerId ,Buyer = SCD1.Buyer FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPurchaseOrder] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimPurchaseOrder__Type1Update] AS SCD1 ON Dim.PurchaseOrderAK = SCD1.PurchaseOrderAK " / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimPurchaseOrder] SET PurchaseOrderAK = SCD1.PurchaseOrderAK ,FiscalYear = SCD1.FiscalYear ,PurchaseOrderNumber = SCD1.PurchaseOrderNumber ,PoStatusCode = SCD1.PoStatusCode ,PoStatus = SCD1.PoStatus ,ReceivingStatusCode = SCD1.ReceivingStatusCode ,ReceivingStatus = SCD1.ReceivingStatus ,PayStatusCode = SCD1.PayStatusCode ,PayStatus = SCD1.PayStatus ,PoTypeCode = SCD1.PoTypeCode ,PoType = SCD1.PoType ,BuyerId = SCD1.BuyerId ,Buyer = SCD1.Buyer FROM [EnterpriseDW].[dbo].[DimPurchaseOrder] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimPurchaseOrder__Type1Update] AS SCD1 ON Dim.PurchaseOrderAK = SCD1.PurchaseOrderAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimPurchaseOrder dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimPurchaseOrder
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPurchaseOrder] SET PurchaseOrderAK = SCD1.PurchaseOrderAK ,FiscalYear = SCD1.FiscalYear ,PurchaseOrderNumber = SCD1.PurchaseOrderNumber ,PoStatusCode = SCD1.PoStatusCode ,PoStatus = SCD1.PoStatus ,ReceivingStatusCode = SCD1.ReceivingStatusCode ,ReceivingStatus = SCD1.ReceivingStatus ,PayStatusCode = SCD1.PayStatusCode ,PayStatus = SCD1.PayStatus ,PoTypeCode = SCD1.PoTypeCode ,PoType = SCD1.PoType ,BuyerId = SCD1.BuyerId ,Buyer = SCD1.Buyer FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPurchaseOrder] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimPurchaseOrder__Type1Update] AS SCD1 ON Dim.PurchaseOrderAK = SCD1.PurchaseOrderAK "
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False