| |
Automatic Linking of Related Tables
Applaud also includes a unique ability to automatically "link" related rows in related tables, making it easy to view the actual data values that are involved in a transformation. For example, suppose that you find that a transformation has resulted in an error in a specific row in a target table. When you click on that row using Applaud's on-line query screens, Applaud automatically provides an immediate link to every related row in every related table. This process automatically links all related tables - all source system tables, all target system tables, all staging tables, all crosswalk/look-up tables, and all tables in the Applaud data repository. Analysis of the interrelated data is as simple as clicking on a table and viewing the related data in the table. It is then easy to determine if the problem is due to invalid source system data, incorrect values in a crosswalk/look-up table, erroneous assumptions regarding the source data, incorrect transformation logic, etc. This dramatically speeds the time required to perform data analysis.
Post-Implementation Audit
Applaud's analytical tools can also be used in conjunction with load tools to perform post-implementation audit and analysis. Applaud can quickly (and if desired continually) test new system data to ensure that processes are operating properly. All of Applaud's analytical tools are independent of the data source. All tools can analyze data in target system tables, as well as the source systems and Applaud's data repository. This makes it easy to ensure that the new system is operating as planned.
Document Data Corrections
Applaud can also make corrections to live production data and can provide simultaneous analysis of the changes made. For example, suppose that it is learned that a specific production process has been operating incorrectly, resulting in several RDBMS tables containing incorrect data. Applaud can easily make the correction to the affected data. But more important, Applaud's analytical tools can easily provide a complete audit trail, showing the "before" and "after" values for every change as an integrated part of the correction. With Applaud, all changes are fully documented.
Parallel Testing Tools
Applaud’s analytical tools may also be used to test the results of parallel runs. For example, data following a parallel test may be quickly extracted (from both the old legacy system and the new system being implemented), and loaded into the Applaud data repository for analysis. It is then easy to compare the results of the legacy system runs to the results of the new system runs to validate the parallel test. The table-linking feature described above can be used to analyze all related data to find the cause of the problem. With Applaud, parallel test discrepancies are quickly identified and resolved.
|
|
|
|