DELETE FROM [EnterpriseDW] .[dbo].[DimBudgetComponentType] WHERE BudgetComponentTypeSK IN ( SELECT BudgetComponentTypeSK FROM [dbo].[Obsolete_DimBudgetComponentType] obs WHERE obs.DoNotDeleteFlag = 0 )

" DELETE FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "] .[dbo].[DimBudgetComponentType] WHERE BudgetComponentTypeSK IN ( SELECT BudgetComponentTypeSK FROM [dbo].[Obsolete_DimBudgetComponentType] obs WHERE obs.DoNotDeleteFlag = 0 ) "

This is the SQL statement that will delete obsolete records from the DimGlTransDetail table.

EnterpriseDW

Configuration setting in SSIS_Configurations that specifies the name of the Enterprise Data Warehouse.

N/A

If the Enterprise Data Warehouse resides on a different server from the DWStaging and DWoperations databases, a linked server must be defined and the name populated into the Var_EDWLinkedServername. If it resides on the same server, this setting must be set to ?N/A?. This is a configuration setting from SSIS_Configurations.

/* SQL INSERT into DimBudgetComponentType from New Temp Table */ INSERT INTO [EnterpriseDW].[dbo].[DimBudgeted] (BudgetedAK ,BudgetedCode ,Budgeted ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT BudgetedAK ,BudgetedCode ,Budgeted ,RowIsCurrent ,RowStartDate ,RowEndDate FROM Staged_dbo_DimBudgeted__New

" /* SQL INSERT into DimBudgetComponentType from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimBudgeted] (BudgetedAK ,BudgetedCode ,Budgeted ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT BudgetedAK ,BudgetedCode ,Budgeted ,RowIsCurrent ,RowStartDate ,RowEndDate FROM Staged_dbo_DimBudgeted__New "

This variable contains the string that will be used to insert any new rows into the DimGlTransDetail table.

/* Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimBudgeted] SET BudgetedAK = SCD1.BudgetedAK ,BudgetedCode = SCD1.BudgetedCode ,Budgeted = SCD1.Budgeted FROM [EnterpriseDW].[dbo].[DimBudgeted] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimBudgeted__Type1Update] AS SCD1 ON Dim.BudgetedAK = SCD1.BudgetedAK

" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimBudgeted] SET BudgetedAK = SCD1.BudgetedAK ,BudgetedCode = SCD1.BudgetedCode ,Budgeted = SCD1.Budgeted FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimBudgeted] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimBudgeted__Type1Update] AS SCD1 ON Dim.BudgetedAK = SCD1.BudgetedAK "

The SQL string that will update any changed rows in the DimGlTransDetail dimension.