Stage Table for Fact Data
2 posters
Page 1 of 1
Re: Stage Table for Fact Data
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.
Similar topics
» Design a snapshot Fact table in data mart from compliance-enable fact table in enterprise data warehouse
» Data in a fact or dimenzion table or bridge table
» SCD or data in FACT TABLE
» Show just data that are relavant to fact table
» Sparse data in fact table
» Data in a fact or dimenzion table or bridge table
» SCD or data in FACT TABLE
» Show just data that are relavant to fact table
» Sparse data in fact table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum