| Name |
DeleteFromDimension |
| Value |
 Expression: "
DELETE
FROM
" + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "] .[dbo].[DimOrgUnit]
WHERE OrgUnitSK IN
(
SELECT OrgUnitSK
FROM [dbo].[Obsolete_DimOrgUnit] obs
WHERE obs.DoNotDeleteFlag = 0
)
"
DELETE
FROM
[EnterpriseDW] .[dbo].[DimOrgUnit]
WHERE OrgUnitSK IN
(
SELECT OrgUnitSK
FROM [dbo].[Obsolete_DimOrgUnit] obs
WHERE obs.DoNotDeleteFlag = 0
)
|
| Value Type |
String |
| Description |
This is the SQL Statement that will delete records from the DimOrgUnit table if they were deleted from the Source System. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::DeleteFromDimension |
| Evaluate As Expression |
True |
| Expression |
"
DELETE
FROM
" + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "] .[dbo].[DimOrgUnit]
WHERE OrgUnitSK IN
(
SELECT OrgUnitSK
FROM [dbo].[Obsolete_DimOrgUnit] obs
WHERE obs.DoNotDeleteFlag = 0
)
" |
| ID |
73818653-2c2e-4b0a-95e5-aad8e2c36c56 |
| Raise Changed Event |
False |
Properties
