Variable - SCD1UpdateDimPayable

Property	Value
Name	SCD1UpdateDimPayable
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPayable] SET PayableAK = SCD1.PayableAK ,FiscalYear = SCD1.FiscalYear ,PayableNumber = SCD1.PayableNumber ,OriginCode = SCD1.OriginCode ,Origin = SCD1.Origin ,ReferenceTypeCode = SCD1.ReferenceTypeCode ,ReferenceType = SCD1.ReferenceType ,ReferenceNumber = SCD1.ReferenceNumber ,PaymentTypeCode = SCD1.PaymentTypeCode ,PaymentType = SCD1.PaymentType ,PaymentTypeNumber = SCD1.PaymentTypeNumber ,PayableStatusCode = SCD1.PayableStatusCode ,PayableStatus = SCD1.PayableStatus ,PayableDate = SCD1.PayableDate ,PaymentDate = SCD1.PaymentDate ,PaymentXrefNbr = SCD1.PaymentXrefNbr FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPayable] AS [DIM] INNER JOIN [dbo].[Staged_dbo / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimPayable] SET PayableAK = SCD1.PayableAK ,FiscalYear = SCD1.FiscalYear ,PayableNumber = SCD1.PayableNumber ,OriginCode = SCD1.OriginCode ,Origin = SCD1.Origin ,ReferenceTypeCode = SCD1.ReferenceTypeCode ,ReferenceType = SCD1.ReferenceType ,ReferenceNumber = SCD1.ReferenceNumber ,PaymentTypeCode = SCD1.PaymentTypeCode ,PaymentType = SCD1.PaymentType ,PaymentTypeNumber = SCD1.PaymentTypeNumber ,PayableStatusCode = SCD1.PayableStatusCode ,PayableStatus = SCD1.PayableStatus ,PayableDate = SCD1.PayableDate ,PaymentDate = SCD1.PaymentDate ,PaymentXrefNbr = SCD1.PaymentXrefNbr FROM [EnterpriseDW].[dbo].[DimPayable] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimPayable__Type1Update] AS SCD1 ON Dim.PayableAK = SCD1.PayableAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimPayable dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimPayable
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPayable] SET PayableAK = SCD1.PayableAK ,FiscalYear = SCD1.FiscalYear ,PayableNumber = SCD1.PayableNumber ,OriginCode = SCD1.OriginCode ,Origin = SCD1.Origin ,ReferenceTypeCode = SCD1.ReferenceTypeCode ,ReferenceType = SCD1.ReferenceType ,ReferenceNumber = SCD1.ReferenceNumber ,PaymentTypeCode = SCD1.PaymentTypeCode ,PaymentType = SCD1.PaymentType ,PaymentTypeNumber = SCD1.PaymentTypeNumber ,PayableStatusCode = SCD1.PayableStatusCode ,PayableStatus = SCD1.PayableStatus ,PayableDate = SCD1.PayableDate ,PaymentDate = SCD1.PaymentDate ,PaymentXrefNbr = SCD1.PaymentXrefNbr FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPayable] AS [DIM] INNER JOIN [dbo].[Staged_dbo
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False