| Name |
Delete_FactStudentTotalFees |
| Value |
 Expression: "DELETE FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentTotalFees]
WHERE StudentTermSK
IN
(
SELECT FactPaid.StudentTermSK
FROM FactStudentTotalFees_Staging StgeFact
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentTerm] StTerm
ON
(
StgeFact.StudentTermAK = StTerm.StudentTermAK
)
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentTotalFees] FactPaid
ON
(
FactPaid.StudentTermSK = StTerm.StudentTermSK
)
)
"
DELETE FROM [EnterpriseDW].[dbo].[FactStudentTotalFees]
WHERE StudentTermSK
IN
(
SELECT FactPaid.StudentTermSK
FROM FactStudentTotalFees_Staging StgeFact
INNER JOIN [EnterpriseDW].[dbo].[DimStudentTerm] StTerm
ON
(
StgeFact.StudentTermAK = StTerm.StudentTermAK
)
INNER JOIN [EnterpriseDW].[dbo].[FactStudentTotalFees] FactPaid
ON
(
FactPaid.StudentTermSK = StTerm.StudentTermSK
)
)
|
| Value Type |
String |
| Description |
This is the SQL statement that will delete Fact Records that will be reloaded. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::Delete_FactStudentTotalFees |
| Evaluate As Expression |
True |
| Expression |
"DELETE FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentTotalFees]
WHERE StudentTermSK
IN
(
SELECT FactPaid.StudentTermSK
FROM FactStudentTotalFees_Staging StgeFact
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentTerm] StTerm
ON
(
StgeFact.StudentTermAK = StTerm.StudentTermAK
)
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentTotalFees] FactPaid
ON
(
FactPaid.StudentTermSK = StTerm.StudentTermSK
)
)
"
|
| ID |
28533530-9eaa-4cc2-b51a-3bb04aa95821 |
| Raise Changed Event |
False |
Properties
