Working SQL Server 2005 T-SQL script for slowly changing dimensions type 2

I need a simple working script for Kimball Slowly Changing Dimensions 2 in T-SQL for SQL Server 2005.

Staging area customer table January:

CustID, LastName, FirstName, Street, ZIP, Town

Staging area customer table February:

CustID, LastName, FirstName, Street, ZIP, Town

Dimension table:

SurrogateKey, CustID, LastName, FirstName, Street, ZIP, Town, valid_from, valid_to, delete_flag

Create the code to fill dimension table.

Skills: Data Processing

See more: slowly changing dimensions sql server sql script, slowly changing dimension type sql script, no working, dimension data, data dimensions, customer table, type slowly changing dimensions sql server, sql server slowly changing dimension sql script, tsql script, slowly changing dimension tsql, sql sql server service status, sql server 2005 job scripting sql, t-sql in, server code, t , t-sql;, t-, t, sql, SQL Server, sql server c, sql script , sql data, Sql code, sql c

About the Employer:
( 1 review ) Sponheim, Germany

Project ID: #245340

Awarded to:


I have made SCD in SSIS, so transfer this solution to simple script in T-SQL will take me several hours.

$120 USD in 1 day
(1 Review)

8 freelancers are bidding on average $131 for this job


Hello, understood the definition. Unabhaengig davon, gibt es Beispieldaten zum Testen ? mhwse, US central time

$50 USD in 2 days
(1 Review)

Exonics IT Solutions, Davangere, india phone : +91 08192 223566

$100 USD in 5 days
(0 Reviews)

Hello Sir Please check PMB Hostech Support is one of leading Business and Solution providing organization operating in India from last two years, catering to requirements of clients across globe. We can get the j More

$250 USD in 1 day
(0 Reviews)

it can be done in two days from synoptictechnolgies

$100 USD in 2 days
(0 Reviews)

Jwala Gari, DBA (oracle, MySql ), SQL programming . India.

$75 USD in 2 days
(0 Reviews)

it can be done in three days.

$200 USD in 3 days
(0 Reviews)

Interested to do your project,we will do your script in T-SQL as per your need ,please contact me for more details,

$150 USD in 5 days
(0 Reviews)