| Name |
SQL_FactEnrollmentSnapshot_RemoveOldRecords |
| Value |
 Expression: "
DELETE
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.FactEnrollmentSnapshot
WHERE EnrollmentSnapshotSK NOT IN
(
SELECT fes.EnrollmentSnapshotSK
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.FactEnrollmentSnapshot fes
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.DimRelativeDay drd
ON (drd.RelativeDaySK = fes.RelativeDaySK)
INNER JOIN dbo.FactEnrollmentSnapshot_TermRelativeDays festrd
ON (
festrd.Term = drd.Term
AND
festrd.RelativeDayNumber = drd.RelativeDayNumber
)
)
"
DELETE
FROM [EnterpriseDW].dbo.FactEnrollmentSnapshot
WHERE EnrollmentSnapshotSK NOT IN
(
SELECT fes.EnrollmentSnapshotSK
FROM [EnterpriseDW].dbo.FactEnrollmentSnapshot fes
INNER JOIN [EnterpriseDW].dbo.DimRelativeDay drd
ON (drd.RelativeDaySK = fes.RelativeDaySK)
INNER JOIN dbo.FactEnrollmentSnapshot_TermRelativeDays festrd
ON (
festrd.Term = drd.Term
AND
festrd.RelativeDayNumber = drd.RelativeDayNumber
)
)
|
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::SQL_FactEnrollmentSnapshot_RemoveOldRecords |
| Evaluate As Expression |
True |
| Expression |
"
DELETE
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.FactEnrollmentSnapshot
WHERE EnrollmentSnapshotSK NOT IN
(
SELECT fes.EnrollmentSnapshotSK
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.FactEnrollmentSnapshot fes
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.DimRelativeDay drd
ON (drd.RelativeDaySK = fes.RelativeDaySK)
INNER JOIN dbo.FactEnrollmentSnapshot_TermRelativeDays festrd
ON (
festrd.Term = drd.Term
AND
festrd.RelativeDayNumber = drd.RelativeDayNumber
)
)
"
|
| ID |
24e993e3-4216-4942-8ce5-e9cd2ccd9bcc |
| Raise Changed Event |
False |
Properties
