| Name |
UpdateFactGlRollOverBalances |
| Value |
 Expression: "
/*
Sample Update Type1 to Dim
*/
UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactGlRollOverBalances]
SET DateSK = UPD1.DateSK
,OrgUnitSK = UPD1.OrgUnitSK
,GlCodeSK = UPD1.GlCodeSK
,GlAccountSK = UPD1.GlAccountSK
,Amount = UPD1.Amount
FROM [EnterpriseDW].[dbo].[FactGlRollOverBalances] AS [FACT]
INNER JOIN [dbo].[Staged_dbo_FactGlRollOverBalances__Update] AS UPD1
ON (FACT.GlAccountSK = UPD1.GlAccountSK
AND FACT.DateSK = UPD1.DateSK
AND FACT.GlCodeSK = UPD1.GlCodeSK
AND FACT.OrgUnitSK = UPD1.OrgUnitSK)
"
/*
Sample Update Type1 to Dim
*/
UPDATE [EnterpriseDW].[dbo].[FactGlRollOverBalances]
SET DateSK = UPD1.DateSK
,OrgUnitSK = UPD1.OrgUnitSK
,GlCodeSK = UPD1.GlCodeSK
,GlAccountSK = UPD1.GlAccountSK
,Amount = UPD1.Amount
FROM [EnterpriseDW].[dbo].[FactGlRollOverBalances] AS [FACT]
INNER JOIN [dbo].[Staged_dbo_FactGlRollOverBalances__Update] AS UPD1
ON (FACT.GlAccountSK = UPD1.GlAccountSK
AND FACT.DateSK = UPD1.DateSK
AND FACT.GlCodeSK = UPD1.GlCodeSK
AND FACT.OrgUnitSK = UPD1.OrgUnitSK)
|
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::UpdateFactGlRollOverBalances |
| Evaluate As Expression |
True |
| Expression |
"
/*
Sample Update Type1 to Dim
*/
UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[FactGlRollOverBalances]
SET DateSK = UPD1.DateSK
,OrgUnitSK = UPD1.OrgUnitSK
,GlCodeSK = UPD1.GlCodeSK
,GlAccountSK = UPD1.GlAccountSK
,Amount = UPD1.Amount
FROM [EnterpriseDW].[dbo].[FactGlRollOverBalances] AS [FACT]
INNER JOIN [dbo].[Staged_dbo_FactGlRollOverBalances__Update] AS UPD1
ON (FACT.GlAccountSK = UPD1.GlAccountSK
AND FACT.DateSK = UPD1.DateSK
AND FACT.GlCodeSK = UPD1.GlCodeSK
AND FACT.OrgUnitSK = UPD1.OrgUnitSK)
"
|
| ID |
0d8fada0-04d2-4e6e-8fe4-c91137dbe948 |
| Raise Changed Event |
False |
Properties
