| Name |
SCD1UpdateDimRelativeDay |
| Value |
 Expression:
"
/* UPDATE SCD1 in DimRelativeDay from DWOperations SCD1 Temp Table */
UPDATE Dim
SET
TermYear = SCD1.TermYear
, TermTypeCode = SCD1.TermTypeCode
, TermTitle = SCD1.TermTitle
, RelativeDay = SCD1.RelativeDay
, RelativeDayDate = SCD1.RelativeDayDate
, RelativeDayDateSK = SCD1.RelativeDayDateSK
FROM
" + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimRelativeDay]
as Dim
INNER JOIN dbo.Staged_dbo_DimRelativeDay__Type1Update SCD1
ON Dim.Term = SCD1.Term and Dim.RelativeDayNumber = SCD1.RelativeDayNumber
"
/* UPDATE SCD1 in DimRelativeDay from DWOperations SCD1 Temp Table */
UPDATE Dim
SET
TermYear = SCD1.TermYear
, TermTypeCode = SCD1.TermTypeCode
, TermTitle = SCD1.TermTitle
, RelativeDay = SCD1.RelativeDay
, RelativeDayDate = SCD1.RelativeDayDate
, RelativeDayDateSK = SCD1.RelativeDayDateSK
FROM
[EnterpriseDW].[dbo].[DimRelativeDay]
as Dim
INNER JOIN dbo.Staged_dbo_DimRelativeDay__Type1Update SCD1
ON Dim.Term = SCD1.Term and Dim.RelativeDayNumber = SCD1.RelativeDayNumber
|
| Value Type |
String |
| Description |
This variable contains the SQL statement that is used to update the changed rows in the DimTerm table |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::SCD1UpdateDimRelativeDay |
| Evaluate As Expression |
True |
| Expression |
"
/* UPDATE SCD1 in DimRelativeDay from DWOperations SCD1 Temp Table */
UPDATE Dim
SET
TermYear = SCD1.TermYear
, TermTypeCode = SCD1.TermTypeCode
, TermTitle = SCD1.TermTitle
, RelativeDay = SCD1.RelativeDay
, RelativeDayDate = SCD1.RelativeDayDate
, RelativeDayDateSK = SCD1.RelativeDayDateSK
FROM
" + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimRelativeDay]
as Dim
INNER JOIN dbo.Staged_dbo_DimRelativeDay__Type1Update SCD1
ON Dim.Term = SCD1.Term and Dim.RelativeDayNumber = SCD1.RelativeDayNumber
" |
| ID |
d487061d-385a-445b-891e-85e67723af13 |
| Raise Changed Event |
False |
Properties
