| Name |
SQL_FactStudentGrades_RePointRecords |
| Value |
 Expression: "
UPDATE " + @[User::EDWDBName] + ".dbo.FactStudentGrades
SET StudentSK = obs_std.NewStudentSK
FROM " + @[User::EDWDBName] + ".dbo.FactStudentGrades 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.FactStudentGrades
SET StudentSK = obs_std.NewStudentSK
FROM EnterpriseDW.dbo.FactStudentGrades 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::SQL_FactStudentGrades_RePointRecords |
| Evaluate As Expression |
True |
| Expression |
"
UPDATE " + @[User::EDWDBName] + ".dbo.FactStudentGrades
SET StudentSK = obs_std.NewStudentSK
FROM " + @[User::EDWDBName] + ".dbo.FactStudentGrades 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 |
303db5d7-5fa5-425d-9803-d4bf16b085d8 |
| Raise Changed Event |
False |
Properties
