Optim - Overview -- IV

About Archive Files

An Archive File contains the selected, relationally intact data described in an Access Definition and the object definitions needed to re-create the database, if necessary.

The Archive File is stored locally on the client system or on a shared file server, or can be stored on secondary media such as a zip disk or a backup device. Archive Directory entries provide general information about each Archive File and any Archive Indexes for the file.

After you have extracted data and created an Archive File, you can browse the contents of the file to answer questions or satisfy a customer request. You can search Archive Directory entries, Archive Index Files, and Archive Files, using criteria for the files and data of interest. If necessary, you can restore selected data from the Archive File.

 

About Compare Requests

Use the Compare Process to compare sets of relational data from several databases and create a Compare File that allows you to browse the results.

A Compare Request identifies the sources of the data to compare and the parameters needed to run the comparison. When you create a Compare Request, you must specify the:

• Compare file to store the compared rows of data.
• Comparison mode to compare Single Table Compare Mode or Multiple Tables Compare Mode.
• Run mode for extracting the source data from two or more tables.
• Source tables for the data to compare. Define a Column Map or Table Map appropriate for the selected comparison mode.

Primary Key or Match Key to match rows from Source 1 with those in Source 2.

Table Maps and Column Maps in a Process Request

When you create a request to use Move (to convert, insert, or load data), Archive (to restore data using an Insert or Load Process), or Compare (to compare data), you can specify a Table Map and optional Column Maps to have more control over the data you want to process.

Convert, Insert, or Load Data

When you create a request to convert, insert, or load data, Table Map provide a way to correlate tables from a Source File with the destination tables in the same or a different database. You can modify destination table names or exclude tables from a process

Note: Some of the articles are grab from various Websites / Blogs.