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
Parent topic