| Name |
SQL_FactEnrollmentActivity_RePointRecords_DimStudentTerm |
| Value |
 Expression: "UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) +"[" + @[User::EDWDBName] + "].dbo.FactEnrollmentActivity
SET StudentTermSK = NEW_d_StdTrm.StudentTermSK
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.FactEnrollmentActivity f_enract
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.DimStudentTerm OLD_d_StdTrm
ON (OLD_d_StdTrm.StudentTermSK = f_enract.StudentTermSK)
INNER JOIN dbo.Obsolete_DimStudent obs_DimStd
ON (obs_DimStd.OldStudentIdAK = OLD_d_StdTrm.StudentId)
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.DimStudentTerm NEW_d_StdTrm
ON (
NEW_d_StdTrm.StudentId = obs_DimStd.NewStudentIdAK AND
NEW_d_StdTrm.Term = OLD_d_StdTrm.Term
)
WHERE OLD_d_StdTrm.RowIsCurrent = 'Y'
AND NEW_d
UPDATE [EnterpriseDW].dbo.FactEnrollmentActivity
SET StudentTermSK = NEW_d_StdTrm.StudentTermSK
FROM [EnterpriseDW].dbo.FactEnrollmentActivity f_enract
INNER JOIN [EnterpriseDW].dbo.DimStudentTerm OLD_d_StdTrm
ON (OLD_d_StdTrm.StudentTermSK = f_enract.StudentTermSK)
INNER JOIN dbo.Obsolete_DimStudent obs_DimStd
ON (obs_DimStd.OldStudentIdAK = OLD_d_StdTrm.StudentId)
INNER JOIN [EnterpriseDW].dbo.DimStudentTerm NEW_d_StdTrm
ON (
NEW_d_StdTrm.StudentId = obs_DimStd.NewStudentIdAK AND
NEW_d_StdTrm.Term = OLD_d_StdTrm.Term
)
WHERE OLD_d_StdTrm.RowIsCurrent = 'Y'
AND NEW_d_StdTrm.RowIsCurrent = 'Y';
|
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::SQL_FactEnrollmentActivity_RePointRecords_DimStudentTerm |
| Evaluate As Expression |
True |
| Expression |
"UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) +"[" + @[User::EDWDBName] + "].dbo.FactEnrollmentActivity
SET StudentTermSK = NEW_d_StdTrm.StudentTermSK
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.FactEnrollmentActivity f_enract
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.DimStudentTerm OLD_d_StdTrm
ON (OLD_d_StdTrm.StudentTermSK = f_enract.StudentTermSK)
INNER JOIN dbo.Obsolete_DimStudent obs_DimStd
ON (obs_DimStd.OldStudentIdAK = OLD_d_StdTrm.StudentId)
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.DimStudentTerm NEW_d_StdTrm
ON (
NEW_d_StdTrm.StudentId = obs_DimStd.NewStudentIdAK AND
NEW_d_StdTrm.Term = OLD_d_StdTrm.Term
)
WHERE OLD_d_StdTrm.RowIsCurrent = 'Y'
AND NEW_d |
| ID |
9dd50674-85e9-474b-ae01-4d48087f411c |
| Raise Changed Event |
False |
Properties
