| Name |
SQL_FactEnrollmentSnapshot_TermRelativeDays__SELECT_WhereNotInFact |
| Value |
 Expression: "
/*
Query provides list of Terms and RelativeDayDate
where the Term and RelativeDayNumber does not
already exist in the FactEnrollmentSnapshot
fact table.
*/
SELECT
fct_enrll_ss_rd.Term,
--RelativeDayNumber,
cast(fct_enrll_ss_rd.RelativeDayDate AS VARCHAR(10)) AS RelativeDayDate
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 " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.DimRelativeDay dim_rd
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.FactEnrollmentSnapshot fct_enrll_ss
ON (fct_enrll_ss.RelativeDaySK = dim_rd.RelativeDaySK)
) AS Fact_Term_DayNum
ON
(
Fact_Term_DayNum.Term = fct_enrll_
/*
Query provides list of Terms and RelativeDayDate
where the Term and RelativeDayNumber does not
already exist in the FactEnrollmentSnapshot
fact table.
*/
SELECT
fct_enrll_ss_rd.Term,
--RelativeDayNumber,
cast(fct_enrll_ss_rd.RelativeDayDate AS VARCHAR(10)) AS RelativeDayDate
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 AND fct_enrll_ss_rd.Term = '' |
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::SQL_FactEnrollmentSnapshot_TermRelativeDays__SELECT_WhereNotInFact |
| Evaluate As Expression |
True |
| Expression |
"
/*
Query provides list of Terms and RelativeDayDate
where the Term and RelativeDayNumber does not
already exist in the FactEnrollmentSnapshot
fact table.
*/
SELECT
fct_enrll_ss_rd.Term,
--RelativeDayNumber,
cast(fct_enrll_ss_rd.RelativeDayDate AS VARCHAR(10)) AS RelativeDayDate
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 " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.DimRelativeDay dim_rd
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "[" + @[User::EDWDBName] + "].dbo.FactEnrollmentSnapshot fct_enrll_ss
ON (fct_enrll_ss.RelativeDaySK = dim_rd.RelativeDaySK)
) AS Fact_Term_DayNum
ON
(
Fact_Term_DayNum.Term = fct_enrll_ |
| ID |
a75db7aa-7c60-42fb-9890-c382be6f096b |
| Raise Changed Event |
False |
Properties
