Variable - SCD1UpdateDimPayee

Property	Value
Name	SCD1UpdateDimPayee
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPayee] SET PayeeAK = SCD1.PayeeAK ,PayeeId = SCD1.PayeeId ,PayeeSequence = SCD1.PayeeSequence ,PayeeTypeCode = SCD1.PayeeTypeCode ,PayeeType = SCD1.PayeeType ,PayeeName = SCD1.PayeeName ,PayeeNameConsolidated = SCD1.PayeeNameConsolidated ,IsMinority = SCD1.IsMinority ,StateCode = SCD1.StateCode ,State = SCD1.State ,ZipCode = SCD1.ZipCode ,Country = SCD1.Country FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPayee] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimPayee__Type1Update] AS SCD1 ON Dim.PayeeAK = SCD1.PayeeAK " / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimPayee] SET PayeeAK = SCD1.PayeeAK ,PayeeId = SCD1.PayeeId ,PayeeSequence = SCD1.PayeeSequence ,PayeeTypeCode = SCD1.PayeeTypeCode ,PayeeType = SCD1.PayeeType ,PayeeName = SCD1.PayeeName ,PayeeNameConsolidated = SCD1.PayeeNameConsolidated ,IsMinority = SCD1.IsMinority ,StateCode = SCD1.StateCode ,State = SCD1.State ,ZipCode = SCD1.ZipCode ,Country = SCD1.Country FROM [EnterpriseDW].[dbo].[DimPayee] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimPayee__Type1Update] AS SCD1 ON Dim.PayeeAK = SCD1.PayeeAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimPayee dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimPayee
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPayee] SET PayeeAK = SCD1.PayeeAK ,PayeeId = SCD1.PayeeId ,PayeeSequence = SCD1.PayeeSequence ,PayeeTypeCode = SCD1.PayeeTypeCode ,PayeeType = SCD1.PayeeType ,PayeeName = SCD1.PayeeName ,PayeeNameConsolidated = SCD1.PayeeNameConsolidated ,IsMinority = SCD1.IsMinority ,StateCode = SCD1.StateCode ,State = SCD1.State ,ZipCode = SCD1.ZipCode ,Country = SCD1.Country FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPayee] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimPayee__Type1Update] AS SCD1 ON Dim.PayeeAK = SCD1.PayeeAK "
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False