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 DimCheckType from New Temp Table */ INSERT INTO [EnterpriseDW].[dbo].[DimCheckType] (CheckTypeCodeAK ,CheckTypeCode ,CheckType ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT CheckTypeCodeAK ,CheckTypeCode ,CheckType ,RowIsCurrent ,RowStartDate ,RowEndDate FROM Staged_dbo_DimCheckType__New

" /* SQL INSERT into DimCheckType from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimCheckType] (CheckTypeCodeAK ,CheckTypeCode ,CheckType ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT CheckTypeCodeAK ,CheckTypeCode ,CheckType ,RowIsCurrent ,RowStartDate ,RowEndDate FROM Staged_dbo_DimCheckType__New "

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

/* Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimCheckType] SET CheckTypeCodeAK = SCD1.CheckTypeCodeAK ,CheckTypeCode = SCD1.CheckTypeCode ,CheckType = SCD1.CheckType FROM [EnterpriseDW].[dbo].[DimCheckType] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimCheckType__Type1Update] AS SCD1 ON Dim.CheckTypeCodeAK = SCD1.CheckTypeCodeAK

" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimCheckType] SET CheckTypeCodeAK = SCD1.CheckTypeCodeAK ,CheckTypeCode = SCD1.CheckTypeCode ,CheckType = SCD1.CheckType FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimCheckType] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimCheckType__Type1Update] AS SCD1 ON Dim.CheckTypeCodeAK = SCD1.CheckTypeCodeAK "

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