| Name |
SQL_FactEnrollmentSnapshot_RePointRecords_DimStudent |
| Value |
 Expression: "
UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) +"[" + @[User::EDWDBName] + "].dbo.FactEnrollmentSnapshot
SET StudentSK = obs_std.NewStudentSK
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.FactEnrollmentSnapshot fct
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.DimStudent ds
ON (fct.StudentSK = ds.StudentSK)
INNER JOIN dbo.Obsolete_DimStudent obs_std
ON (obs_std.OldStudentSK = ds.StudentSK)
WHERE ds.RowIsCurrent = 'Y';
"
UPDATE [EnterpriseDW].dbo.FactEnrollmentSnapshot
SET StudentSK = obs_std.NewStudentSK
FROM [EnterpriseDW].dbo.FactEnrollmentSnapshot 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)
WHERE ds.RowIsCurrent = 'Y';
|
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::SQL_FactEnrollmentSnapshot_RePointRecords_DimStudent |
| Evaluate As Expression |
True |
| Expression |
"
UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) +"[" + @[User::EDWDBName] + "].dbo.FactEnrollmentSnapshot
SET StudentSK = obs_std.NewStudentSK
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.FactEnrollmentSnapshot fct
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.DimStudent ds
ON (fct.StudentSK = ds.StudentSK)
INNER JOIN dbo.Obsolete_DimStudent obs_std
ON (obs_std.OldStudentSK = ds.StudentSK)
WHERE ds.RowIsCurrent = 'Y';
"
|
| ID |
46d39084-bfa1-4b18-bcaa-81c12d7fa2cf |
| Raise Changed Event |
False |
Properties
