| Name |
SQL_FactEnrollmentSnapshot_Term__SELECT_WhereNotInFact |
| Value |
/*
Query provides list of Terms
where the Term and RelativeDayNumber does not
already exist in the FactEnrollmentSnapshot
fact table.
*/
SELECT DISTINCT
fct_enrll_ss_rd.Term
FROM dbo.FactEnrollmentSnapshot_TermRelativeDays fct_enrll_ss_rd
LEFT OUTER JOIN
(
--This section produces a distinct list of Terms and RelativeDayNumbers
--that exist in data warehouse FactEnrollmentSnapshot.
SELECT DISTINCT dim_rd.Term, dim_rd.RelativeDayNumber
FROM [EnterpriseDW].dbo.DimRelativeDay dim_rd
INNER JOIN [EnterpriseDW].dbo.FactEnrollmentSnapshot fct_enrll_ss
ON (fct_enrll_ss.RelativeDaySK = dim_rd.RelativeDaySK)
) AS Fact_Term_DayNum
ON
(
Fact_Term_DayNum.Term = fct_enrll_ss_rd.Term
AND
Fact_Term_DayNum.RelativeDayNumber = fct_enrll_ss_rd.RelativeDayNumber
)
WHERE Fact_Term_DayNum.Term IS NULL |
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::SQL_FactEnrollmentSnapshot_Term__SELECT_WhereNotInFact |
| Evaluate As Expression |
False |
| Expression |
|
| ID |
35ab39e8-ef8b-4643-a869-7167631959b7 |
| Raise Changed Event |
False |
Properties
