| Name |
Delete_FactObsStudentTotalFeesForClass |
| Value |
 Expression: "DELETE FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentTotalFeesForClass] WHERE StudentSK IN
(
SELECT OldStudentSK
FROM Obsolete_DimStudent
)
"
DELETE FROM [EnterpriseDW].[dbo].[FactStudentTotalFeesForClass] WHERE StudentSK IN
(
SELECT OldStudentSK
FROM Obsolete_DimStudent
)
|
| Value Type |
String |
| Description |
This is the SQL Statement that deletes the Fact Information that existed for Students processed in the Student ID Merge. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::Delete_FactObsStudentTotalFeesForClass |
| Evaluate As Expression |
True |
| Expression |
"DELETE FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentTotalFeesForClass] WHERE StudentSK IN
(
SELECT OldStudentSK
FROM Obsolete_DimStudent
)
"
|
| ID |
bcd7b905-2cb5-4c1d-bda3-93c7336ad413 |
| Raise Changed Event |
False |
Properties
