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.
Are you interested in this answer? Please click on the order button now to have your task completed by professional writers. Your submission will be unique and customized, so that it is totally plagiarism-free.