Sort and re-sort the load record images to create aggregate records. Generalize keys for aggregate records. Bulk load all the records with referential integrity turned on. Process load exceptions. Index the newly loaded records.
Quality assure the data load.
These data extraction tool providers all aim to automate the process of accessing, transforming, and migrating data. I have tried to take an IS user's perspective in judging what they do and how well their tools map to my overall tasks and worries. As you will see, these tools automate a number of the most difficult tasks in my list of 13 steps, but they also leave me with a lot of messy work to do on my own. A PC or a workstation client acts as the controller for the extraction process. In the most typical configuration, the client PC generates Cobol programs and associated JCL for an IBM host that reads and manipulates source data, and prepares the data for migration and loading into a target DBMS on another machine.