Data warehouse analytics and design- Changing Data
Problems in Data Warehousing
Should Backdated Transactions Change Values in the Data Warehouse?
Due to poor operating practices, a company sometimes has to backdate transactions. These transactions are entered a month or more after they actually occurred. The people in accounting argue that the “historic” information should not change. The standard in the data warehouse transformation process is this: if a transaction has a date that is 40 days old, the data warehouse data for that day will change. Should a backdated transaction not change the “historic” information in the data warehouse?
Remember to cite your sources, provide links to those sources, and/or attach a copy of the article. . Relevant and explained work experience is also appropriate support for your recommendation. The purpose is to provide support for your recommendation and/or position.