| Name |
SQL_FactEnrollmentSnapshot_RePointRecords_DimStudentTerm |
| Value |
 Expression: "UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) +"[" + @[User::EDWDBName] +"].dbo.FactEnrollmentSnapshot
SET StudentTermSK = NEW_d_StdTrm.StudentTermSK
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) +"[" + @[User::EDWDBName] +"].dbo.FactEnrollmentSnapshot 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_Std
UPDATE [EnterpriseDW].dbo.FactEnrollmentSnapshot
SET StudentTermSK = NEW_d_StdTrm.StudentTermSK
FROM [EnterpriseDW].dbo.FactEnrollmentSnapshot 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_FactEnrollmentSnapshot_RePointRecords_DimStudentTerm |
| Evaluate As Expression |
True |
| Expression |
"UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) +"[" + @[User::EDWDBName] +"].dbo.FactEnrollmentSnapshot
SET StudentTermSK = NEW_d_StdTrm.StudentTermSK
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) +"[" + @[User::EDWDBName] +"].dbo.FactEnrollmentSnapshot 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_Std |
| ID |
a8d7f68a-231b-4c0d-8a87-df686b22558c |
| Raise Changed Event |
False |
Properties
