Loading Table or Maintenance Object

The conversion data upload supports two types of the extract:

• Data extract that contains the data for a single target staging table.

  In this case, the upload process inserts records into a single staging table. The input data file consists of similar records, each represents a row in the target table.

• Data extract that contains the data for the group of target staging tables that represent a Maintenance Object.

  In this case, the upload process populates all the tables that belong to a maintenance object. The input data file contains multiple types of records that are inserted into various tables.

  Note: If the data is uploaded for a Maintenance Object, each record has to be prefixed with the table name that is used as record type indicator. This requirement is also mentioned in the input file specification

• The application stores the large volumes of data in partitioned tables. If the Maintenance Object contains partitioned tables, the data should be uploaded in a certain order:

  • During the data upload, the primary table in the Maintenance Object should be loaded first, then the indexes should be rebuilt, followed by the data upload into the child tables