Handling SCD with SSIS

Moderators: chulett, rschirm

Post Reply
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Handling SCD with SSIS

Post by ray.wurlod »

While trolling through the internet I happened uponthis article on a new way to handle Slowly Changing Dimensions (SCD) with SQL Server Integration Services.

It's not related to "our" product suite, but someone here might be interested. At least in finding another SQL Server blog site!

Some other SCDs follow:
  • Specific Carbohydrate Diet

    Semi Conductor Devices

    Senior College Dun Laoghaire

    Scientific Computing Division

    Sydney College of Divinity

    Slot Car Distributors

    Sequential Compression Device (prevents DVT)

    Sickle Cell Disease

    System Context Diagram

    Special Care Dentistry

    Sustainable Community Development

    Saint ClouD (Minnesota)

    Sudden Cardiac Death

    Single Crystal Diffractometer

    Sulphur Chemoluminescence Detector

    Scottish Country Dancing

    Swiss Committee on Dams

    File suffix for Microsoft Schedule+

    (oh, yes) Slowly Changing Dimension
:lol:

Extra credit for anyone who knows how to pronounce Dun Laoghaire (which is the port for Dublin).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Its pronounced "Dun Lairy" :lol: , Right ?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Yup, the exact phonetics and history given here.
http://en.wikipedia.org/wiki/D%C3%BAn_Laoghaire
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

I have noticed that SSIS bloggers tend to outnumber DataStage and Informatica bloggers by about 10 to 1 and they are often coming from an established network of SQL Server code cutters. They have some very detailed discussions on things like SCDs, balancing between ETL and ELT and surrogate key generation. All from an ETL perspective.
Post Reply