Access to archive data performs just like a database.

ODM/Optim Connect must be used to access the archives.

Access using ODM/Optim Connect provides nearline access to archived data.

Archive data access should rarely be required.

Column Map names are a two part name

You can create a new Column Map from the Definitions submenu.

Columns with the same name and compatible data types are not automatically matched.

If a match is not found for a Destination or Source 2 column, the status is NOT USED or REQUIRED.

An Insert process can always insert all the data successfully regardless of the presence of complex referential integrity (RI) cycles.

An Insert process allows for Update/Insert processing in one step; a Load process may not.

An Insert process will be faster than a Load process when inserting large volumes of data.

An Insert process allows you to use Column Maps to transform data; a Load process does not.