| Name |
FactStudentReceiptPayments_RepointRows |
| Value |
 Expression: "
UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentReceiptPayments]
SET StudentSK = obs_std.NewStudentSK
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentReceiptPayments] fct
INNER JOIN " + @[User::EDWDBName] + ".dbo.DimStudent ds
ON (fct.StudentSK = ds.StudentSK)
INNER JOIN dbo.Obsolete_DimStudent obs_std
ON (obs_std.OldStudentSK = ds.StudentSK);
"
UPDATE [EnterpriseDW].[dbo].[FactStudentReceiptPayments]
SET StudentSK = obs_std.NewStudentSK
FROM [EnterpriseDW].[dbo].[FactStudentReceiptPayments] fct
INNER JOIN EnterpriseDW.dbo.DimStudent ds
ON (fct.StudentSK = ds.StudentSK)
INNER JOIN dbo.Obsolete_DimStudent obs_std
ON (obs_std.OldStudentSK = ds.StudentSK);
|
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::FactStudentReceiptPayments_RepointRows |
| Evaluate As Expression |
True |
| Expression |
"
UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentReceiptPayments]
SET StudentSK = obs_std.NewStudentSK
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentReceiptPayments] fct
INNER JOIN " + @[User::EDWDBName] + ".dbo.DimStudent ds
ON (fct.StudentSK = ds.StudentSK)
INNER JOIN dbo.Obsolete_DimStudent obs_std
ON (obs_std.OldStudentSK = ds.StudentSK);
"
|
| ID |
076eb44f-13db-4ea3-ac1d-0c711f6b2672 |
| Raise Changed Event |
False |
Properties
