DataMigrator extracts data from data sources using SQL. The process of applying SQL to heterogeneous data sources is very complex and too broad a subject to easily outline here. However, the following are issues which you control.
Make sure that critical native DBMS optimization fields (primary keys, secondary indexes, and so on) are correctly defined in the synonym. For more information on defining synonyms, see Chapter 6, Managing Metadata, in the Server Administration for UNIX, Windows, OpenVMS, IBMÂ i, and z/OS manual.
iWay Software |