Stage Table for Fact Data

View previous topic View next topic Go down

Stage Table for Fact Data

Post  rpcasey001 on 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

View user profile http://www.R-P-C-Group.com

Back to top Go down

Re: Stage Table for Fact Data

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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