Designing Your Application

Data warehouses and/or data marts are created for a variety of reasons. Knowing the factors leading to the decision for extracting or moving data will help you identify the issues for DM management that will have the greatest impact on your success. The ultimate goal is always to have an automated process that moves and converts all of your data in a very small period of time. However, it helps to know what issues are most important in your company's criteria for a successful data warehouse. Are you consuming large amounts of time in the management of 3GL extraction programs and load routines? Are you uncomfortable with ad hoc user access to production legacy systems? Is your network unable to handle the performance requirements for decision support and analysis?

If you consider the reasons for warehousing, your attention will be properly focused on the critical variables. DataMigrator provides you with the flexibility to control the variables inherent at your site and in your data.

From an application perspective, you must evaluate what will direct your overall data movement strategy. Considering the following questions will help you learn more about the capabilities of DataMigrator and how to control them.


iWay Software