Home > Archive > MS SQL Server security > April 2005 > Incremental Load to dataWarehouse Table









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Incremental Load to dataWarehouse Table
marcmc

2005-04-06, 8:01 pm

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?
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com