Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Stage Table for Fact Data

Go down

Stage Table for Fact Data Empty Stage Table for Fact Data

Post  rpcasey001 Tue Jun 02, 2009 10:20 am

Is it a best practice to truncate a stage table before every load?

--- RPC

rpcasey001

Posts : 7
Join date : 2009-05-29

http://www.R-P-C-Group.com

Back to top Go down

Stage Table for Fact Data Empty Re: Stage Table for Fact Data

Post  ngalemmo Tue Jun 02, 2009 1:33 pm

In general, yes. Just make sure you have a mechanism to recover old data if a load went bad, or if you accidently start a new load when you should not. For example, you could have a step at the end of a load process that streams the staged data to a text file that is zipped and archived. Or, if your initial source is a flat file, zip and archive it so it can be recovered at a later date.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum