Design and Theory

Technical Article

Surrounding the ETL Requirements

  • Article

November 13, 2004 / Issue TOC

Surrounding the ETL Requirements

Before designing an ETL system, you must first understand all of your business needs.

By Ralph Kimball , Margy Ross

Ideally, the design of your extract, transform, and load (ETL) system begins with one of the toughest challenges: surrounding the requirements. By this we mean gathering in one place all the known requirements, realities, and constraints affecting the ETL system. The list of requirements is pretty overwhelming, but it's essential to lay them on the table before launching a data warehouse project.

The requirements are mostly things you must live with and adapt your system to. Within the framework of your requirements, you'll have many places where you can make your own decisions, exercise your judgment, and leverage your creativity, but the requirements are just what they're named. They are required.


1,855 reads

Technical Article

The Three Ms of BI: Manage, Monitor and Model

  • Article

Business intelligence is awash in so many products, buzzwords and technologies that it is often hard to see the forest for the trees. It is at times like this that I put on my industry analyst's cap and muse, "Hmm, what is this: manage, monitor or model?" This tripartite way of looking at the world has served my clients well, and I thought I'd pass it along.


2,090 reads


Amazon RDS Custom for SQL Server – A new beginning


Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was...

Getting Started with the Advent of Code as a #SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

Your next step in the cloud


Over the last nine months I’ve presented (virtually) eleven times on a variety of...

Read the latest Blogs


Automation testing Training in Canada

By jhonautomationa

Automation testing is the best option for the candidates who are looking to make...

Issue when joining 3 temp tables

By JeremyU

Hey everyone, I have an issue joining 3 temp tables. I have such tables...

Row limit for Updates before transaction log fills up

By Lord Slaagh

Hello SSC, I hope everyone is staying safe and healthy. I am using SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers