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
-