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 DimCheckComponentType from New Temp Table */ INSERT INTO [EnterpriseDW].[dbo].[DimCheckComponentType] (CheckComponentTypeAK ,ComponentLineCode ,ComponentLine ,ComponentOneCode ,ComponentOne ,ComponentTwoCode ,ComponentTwo ,ComponentCategory ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT CheckComponentTypeAK ,ComponentLineCode ,ComponentLine ,ComponentOneCode ,ComponentOne ,ComponentTwoCode ,ComponentTwo ,ComponentCategory ,RowIsCurrent ,RowStartDate ,RowEndDate FROM Staged_dbo_DimCheckComponentType__New

" /* SQL INSERT into DimCheckComponentType from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimCheckComponentType] (CheckComponentTypeAK ,ComponentLineCode ,ComponentLine ,ComponentOneCode ,ComponentOne ,ComponentTwoCode ,ComponentTwo ,ComponentCategory ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT CheckComponentTypeAK ,ComponentLineCode ,ComponentLine ,ComponentOneCode ,ComponentOne ,ComponentTwoCode ,ComponentTwo ,ComponentCategory ,RowIsCurrent ,RowStartDate ,RowEndDate FROM Staged_dbo_DimCheckComponentType__New "

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

/* Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimCheckComponentType] SET CheckComponentTypeAK = SCD1.CheckComponentTypeAK ,ComponentLineCode = SCD1.ComponentLineCode ,ComponentLine = SCD1.ComponentLine ,ComponentOneCode = SCD1.ComponentOneCode ,ComponentOne = SCD1.ComponentOne ,ComponentTwoCode = SCD1.ComponentTwoCode ,ComponentTwo = SCD1.ComponentTwo ,ComponentCategory = SCD1.ComponentCategory FROM [EnterpriseDW].[dbo].[DimCheckComponentType] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimCheckComponentType__Type1Update] AS SCD1 ON Dim.CheckComponentTypeAK = SCD1.CheckComponentTypeAK

" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimCheckComponentType] SET CheckComponentTypeAK = SCD1.CheckComponentTypeAK ,ComponentLineCode = SCD1.ComponentLineCode ,ComponentLine = SCD1.ComponentLine ,ComponentOneCode = SCD1.ComponentOneCode ,ComponentOne = SCD1.ComponentOne ,ComponentTwoCode = SCD1.ComponentTwoCode ,ComponentTwo = SCD1.ComponentTwo ,ComponentCategory = SCD1.ComponentCategory FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimCheckComponentType] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimCheckComponentType__Type1Update] AS SCD1 ON Dim.CheckComponentTypeAK = SCD1.CheckComponentTypeAK "

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