locked
What is the best way to setup a staging table RRS feed

  • Question

  • I have about 10M rows per day generated in production. They have a timestamp + type identifier.

    What is the best way to stage them before putting them in the fact table. What is the best way to determine the last record moved from production to staging and from staging to the fact table? Should the staging table be purged after it is loaded or should I be keeping some form of reference?

    Thanks,

    David
    Thursday, May 19, 2005 3:54 PM

Answers