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.

» 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
» 1 to 1 Text Data in a Fact Table
» character data in a fact table?
» Data in a fact or dimenzion table or bridge table
» SCD or data in FACT TABLE
» 1 to 1 Text Data in a Fact Table
» character data in a fact table?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum