Sedang Disiapkan

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.

Kemahiran: Pemprosesan Data

Lihat lebih lanjut: 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

Tentang Majikan:
( 1 ulasan ) Sponheim, Germany

ID Projek: #245340

Dianugerahkan kepada:

mur2000

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

$120 USD dalam sehari
(1 Ulasan)
2.2

8 pekerja bebas membida secara purata $131 untuk pekerjaan ini

mhwse

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

$50 USD dalam 2 hari
(1 Ulasan)
1.0
Exonics

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

$100 USD dalam 5 hari
(0 Ulasan)
0.0
hostechsupport

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 Lagi

$250 USD dalam sehari
(0 Ulasan)
0.0
shaik4321

it can be done in two days from synoptictechnolgies

$100 USD dalam 2 hari
(0 Ulasan)
0.0
jalwa44

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

$75 USD dalam 2 hari
(0 Ulasan)
0.0
Shakil777

it can be done in three days.

$200 USD dalam 3 hari
(0 Ulasan)
0.0
a102

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 dalam 5 hari
(0 Ulasan)
0.0