| Name |
Remove_ExistingEnrollActivity |
| Value |
 Expression: "
/* Remove Rows from FactEnrollmentActivity for the ETL Incremental Begin to End Dates */
DELETE FROM [dbo].[FactEnrollmentActivity]
FROM [dbo].[FactEnrollmentActivity] As EnrollActivity
JOIN [dbo].[DimDate] AS Dates
ON EnrollActivity.DateSK = Dates.DateSK
WHERE Dates.FullDate >= '" + @[User::IncrementalBeginDtTm] + "'
AND Dates.FullDate <= '" + @[User::IncrementalEndDtTm] + "'"
/* Remove Rows from FactEnrollmentActivity for the ETL Incremental Begin to End Dates */
DELETE FROM [dbo].[FactEnrollmentActivity]
FROM [dbo].[FactEnrollmentActivity] As EnrollActivity
JOIN [dbo].[DimDate] AS Dates
ON EnrollActivity.DateSK = Dates.DateSK
WHERE Dates.FullDate >= 'Jan 1 1900 12:00AM'
AND Dates.FullDate <= 'Mar 4 2016 10:33AM' |
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::Remove_ExistingEnrollActivity |
| Evaluate As Expression |
True |
| Expression |
"
/* Remove Rows from FactEnrollmentActivity for the ETL Incremental Begin to End Dates */
DELETE FROM [dbo].[FactEnrollmentActivity]
FROM [dbo].[FactEnrollmentActivity] As EnrollActivity
JOIN [dbo].[DimDate] AS Dates
ON EnrollActivity.DateSK = Dates.DateSK
WHERE Dates.FullDate >= '" + @[User::IncrementalBeginDtTm] + "'
AND Dates.FullDate <= '" + @[User::IncrementalEndDtTm] + "'" |
| ID |
679bb1cd-03af-4f1c-8d55-7bed85e904fd |
| Raise Changed Event |
False |
Properties
