| Name |
SCD1UpdateDimGlTransDetails |
| Value |
 Expression: "
/*
Sample Update Type1 to Dim
*/
UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimGlTransDetail] SET GlDetailAK = SCD1.GlDetailAK
,GlCalendarPeriod = SCD1.GlCalendarPeriod
,JournalNumber = SCD1.JournalNumber
,LineNumber = SCD1.LineNumber
,JournalTypeCode = SCD1.JournalTypeCode
,JournalType = SCD1.JournalType
,JournalGrouping = SCD1.JournalGrouping
,BudgetTypeCode = SCD1.BudgetTypeCode
,BudgetType = SCD1.BudgetType
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimGlTransDetail] AS [DIM]
INNER JOIN [dbo].[Staged_dbo_DimGlTransDetail__Type1Update] AS SCD1
ON Dim.GlDetailAK = SCD1.GlDetailAK
"
/*
Sample Update Type1 to Dim
*/
UPDATE [EnterpriseDW].[dbo].[DimGlTransDetail] SET GlDetailAK = SCD1.GlDetailAK
,GlCalendarPeriod = SCD1.GlCalendarPeriod
,JournalNumber = SCD1.JournalNumber
,LineNumber = SCD1.LineNumber
,JournalTypeCode = SCD1.JournalTypeCode
,JournalType = SCD1.JournalType
,JournalGrouping = SCD1.JournalGrouping
,BudgetTypeCode = SCD1.BudgetTypeCode
,BudgetType = SCD1.BudgetType
FROM [EnterpriseDW].[dbo].[DimGlTransDetail] AS [DIM]
INNER JOIN [dbo].[Staged_dbo_DimGlTransDetail__Type1Update] AS SCD1
ON Dim.GlDetailAK = SCD1.GlDetailAK
|
| Value Type |
String |
| Description |
The SQL string that will update any changed rows in the DimGlTransDetail dimension. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::SCD1UpdateDimGlTransDetails |
| Evaluate As Expression |
True |
| Expression |
"
/*
Sample Update Type1 to Dim
*/
UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimGlTransDetail] SET GlDetailAK = SCD1.GlDetailAK
,GlCalendarPeriod = SCD1.GlCalendarPeriod
,JournalNumber = SCD1.JournalNumber
,LineNumber = SCD1.LineNumber
,JournalTypeCode = SCD1.JournalTypeCode
,JournalType = SCD1.JournalType
,JournalGrouping = SCD1.JournalGrouping
,BudgetTypeCode = SCD1.BudgetTypeCode
,BudgetType = SCD1.BudgetType
FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimGlTransDetail] AS [DIM]
INNER JOIN [dbo].[Staged_dbo_DimGlTransDetail__Type1Update] AS SCD1
ON Dim.GlDetailAK = SCD1.GlDetailAK
"
|
| ID |
d46fb6fd-e48a-41c9-b823-d24774e927d3 |
| Raise Changed Event |
False |
Properties
