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