| Name |
Delete_FactStudentFeesPaid |
| Value |
 Expression: "DELETE FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentFeesPaid]
WHERE StudentTermSK
IN
(
SELECT FactPaid.StudentTermSK
FROM FactStudentFeesPaid_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].[FactStudentFeesPaid] FactPaid
ON
(
FactPaid.StudentTermSK = StTerm.StudentTermSK
)
)
"
DELETE FROM [EnterpriseDW].[dbo].[FactStudentFeesPaid]
WHERE StudentTermSK
IN
(
SELECT FactPaid.StudentTermSK
FROM FactStudentFeesPaid_Staging StgeFact
INNER JOIN [EnterpriseDW].[dbo].[DimStudentTerm] StTerm
ON
(
StgeFact.StudentTermAK = StTerm.StudentTermAK
)
INNER JOIN [EnterpriseDW].[dbo].[FactStudentFeesPaid] 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_FactStudentFeesPaid |
| Evaluate As Expression |
True |
| Expression |
"DELETE FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactStudentFeesPaid]
WHERE StudentTermSK
IN
(
SELECT FactPaid.StudentTermSK
FROM FactStudentFeesPaid_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].[FactStudentFeesPaid] FactPaid
ON
(
FactPaid.StudentTermSK = StTerm.StudentTermSK
)
)
"
|
| ID |
28533530-9eaa-4cc2-b51a-3bb04aa95821 |
| Raise Changed Event |
False |
Properties
