Incremental Load to dataWarehouse Table

From: marcmc (marcmc_at_discussions.microsoft.com)
Date: 04/06/05 

Date: Wed, 6 Apr 2005 07:03:03 -0700

I have never done it before.

By the term incremental, I mean that I have a fact table and each day I want
to add records to it that do not already exist in the table. I do not want to
truncate and do a full load each day. There are millions of rows.

What is the best approach to thinking about/coding this?

Quantcast