| Name |
FactStudentReceiptTotals_RepointRows |
| Value |
 Expression: "
UPDATE " + @[User::EDWDBName] + ".dbo.FactStudentReceiptTotals
SET StudentSK = obs_std.NewStudentSK
FROM " + @[User::EDWDBName] + ".dbo.FactStudentReceiptTotals 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.FactStudentReceiptTotals
SET StudentSK = obs_std.NewStudentSK
FROM EnterpriseDW.dbo.FactStudentReceiptTotals 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 |
This is the SQL statement that will point any remaining Student Receipt Fact receords to the new Student ID after a Merge. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::FactStudentReceiptTotals_RepointRows |
| Evaluate As Expression |
True |
| Expression |
"
UPDATE " + @[User::EDWDBName] + ".dbo.FactStudentReceiptTotals
SET StudentSK = obs_std.NewStudentSK
FROM " + @[User::EDWDBName] + ".dbo.FactStudentReceiptTotals 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
