ssis 2008 slowly changing dimensions

Hi,

I am trying to build dimensions tables and fact tables, My approach is to do datacleansing in staging level and load dimensions appropriately, I know we have very easy to use wizard in  ssis.But can any bodu let me know any different approach which can improve the performance of packages and also capture scd type1 and type2 appropriately and will have capabiliy to handle incremental loading also.  I am giving the structure of  staging table and dimension table below  please correct me if i am doing anything wrong.

 Thanks.

USE [Enterprise_Cube]
GO
 
/****** Object:  Table [dbo].[Stg_Address]    Script Date: 05/01/2009 11:51:06 ******/
SET ANSI_NULLS ON
GO
 
SET QUOTED_IDENTIFIER ON
GO
 
SET ANSI_PADDING ON
GO
 
CREATE TABLE [dbo].[Stg_Address](
	[AddressID] [int] NOT NULL,
	[STREETADDRESS1] [varchar](50) NULL,
	[STREETADDRESS2] [varchar](50) NULL,
	[STREETADDRESS3] [varchar](50) NULL,
	[CITY] [varchar](50) NULL,
	[STATE] [varchar](50) NULL,
	[PostalCode] [varchar](50) NULL,
	[Country] [varchar](50) NULL,
	[REGIONNAME] [varchar](25) NULL,
	[IATA Code] [varchar](4) NULL,
	[UPSCity] [varchar](50) NULL,
 CONSTRAINT [PK_Stg_Address] PRIMARY KEY CLUSTERED 
(
	[AddressID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
 
GO
 
SET ANSI_PADDING OFF
GO
 
 
--Dimension table:
 
USE [Enterprise_Cube]
GO
 
/****** Object:  Table [dbo].[DimAddress]    Script Date: 05/01/2009 11:51:44 ******/
SET ANSI_NULLS ON
GO
 
SET QUOTED_IDENTIFIER ON
GO
 
SET ANSI_PADDING ON
GO
 
CREATE TABLE [dbo].[DimAddress](
	[AddressUID] [int] IDENTITY(1,1) NOT NULL,
	[AddressID] [int] NULL,
	[STREETADDRESS] [varchar](250) NULL,
	[CITY] [varchar](50) NULL,
	[STATE] [varchar](50) NULL,
	[PostalCode] [varchar](50) NULL,
	[Country] [varchar](50) NULL,
	[REGIONNAME] [varchar](25) NULL,
	[IATA Code] [varchar](4) NULL,
	[UPSCity] [varchar](50) NULL,
	[StartDate] [date] NULL,
	[EndDate] [date] NULL,
	[Status] [bit] NULL,
	[CS_records]  AS (checksum([STREETADDRESS],[CITY],[STATE],[PostalCode],[Country],[REGIONNAME],[IATA Code],[UPSCity])),
 CONSTRAINT [PK_DimAddress] PRIMARY KEY CLUSTERED 
(
	[AddressUID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
 
GO
 
SET ANSI_PADDING OFF
GO
 
ALTER TABLE [dbo].[DimAddress] ADD  CONSTRAINT [DF__Address_D__State__08EA5793]  DEFAULT ('NA') FOR [STATE]
GO
 
ALTER TABLE [dbo].[DimAddress] ADD  CONSTRAINT [DF_DimAddress_Start]  DEFAULT (getdate()) FOR [StartDate]
GO
 
ALTER TABLE [dbo].[DimAddress] ADD  CONSTRAINT [DF_DimAddress_End]  DEFAULT ('99990101') FOR [EndDate]
GO

Select allOpen in new window