Archive for August, 2008

Copy Management Tools and Data Cleanup

As any database or data warehouse administrator will tell you, most of the required consistency checks are complex. Most copy management tools do not have the capability of applying these checks directly. Specifically, a number of products that claim to have this facility implement it by allowing users to code the logic in either SQL, […]

Loading The Data in a Data Warehouse

Once the data is extracted from the source systems, it is then typically loaded into a temporary data store in order for it to be cleaned up and made consistent. These checks can be quite complex, and identify consistency issues when integrating data from a number of data sources. In addition, as data changes over […]