Sarbanes and Data Warehouse:The integrated data repository of data warehouse stores critical information at transactional level and summary levels across different business functions and provide detailed level of data to managers. As of now, in many companies, data that has been stored in data bases are not clean. These databases have several data problems and to comply with SOX, the design of the data warehouse should be changed due to the volumes of data required and complexity of queries issued. The mergers and acquisitions that happen nowadays may change the structure of the data warehouse since the acquiring company must integrate the acquired company’s data into own compliance environment. Data Warehouse provides data in a single view (data warehouse stores information from different heterogeneous resources) for easier reporting. and helps to view and manage data from end-to-end business processes. Sarbanes and Data Model:Scattered information from different transactions is brought into a single data model that provides the base for designing data warehouse and business intelligence reports. |
