| Name |
CheckFactRowCount |
| Value |
 Expression: "
/* SQL Delete from DimCurriculum fromTemp Table */
select count(*) as RWC FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactActiveEnrollmentSnapshot] as Fact
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].DimCurriculum Dim
on
(
Dim.CurriculumSK = Fact.CurriculumSK
)
WHERE Dim.ReferenceNumberAK
in
( SELECT
ReferenceNumberAK
FROM [dbo].[Update_dbo_DimCurriculum]
)
"
/* SQL Delete from DimCurriculum fromTemp Table */
select count(*) as RWC FROM [EnterpriseDW].[dbo].[FactActiveEnrollmentSnapshot] as Fact
INNER JOIN [EnterpriseDW].[dbo].DimCurriculum Dim
on
(
Dim.CurriculumSK = Fact.CurriculumSK
)
WHERE Dim.ReferenceNumberAK
in
( SELECT
ReferenceNumberAK
FROM [dbo].[Update_dbo_DimCurriculum]
)
|
| Value Type |
String |
| Description |
Stores the number of Fact rows that are using the row in a dimension. Will be used to determine if records removed from the Source System can be deleted. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::CheckFactRowCount |
| Evaluate As Expression |
True |
| Expression |
"
/* SQL Delete from DimCurriculum fromTemp Table */
select count(*) as RWC FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactActiveEnrollmentSnapshot] as Fact
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].DimCurriculum Dim
on
(
Dim.CurriculumSK = Fact.CurriculumSK
)
WHERE Dim.ReferenceNumberAK
in
( SELECT
ReferenceNumberAK
FROM [dbo].[Update_dbo_DimCurriculum]
)
" |
| ID |
1906a225-1e89-4ba5-9fe2-f33b9eb10a61 |
| Raise Changed Event |
False |
Properties
