Flatten OCCURS Items

An OCCURS clause is a DMSII construct that describes the number of times an item is present or repeats within a data set. Because relational databases don't have an equivalent construct, additional tables are created for these items, which degrades the performance of update processing. In DATABridge Client, if you don't flatten the OCCURS clauses, a secondary table is created. Each OCCURS clause and its keys are mapped to a single row in that table.

Caution: Make this type of change only before cloning the data source. Otherwise, you may need to reclone.

To handle OCCURS items

  1. In the Explorer view, right-click a data source and choose Customize Data Source.
  2. In the DMSII view, right-click the data source and choose Client Configuration.
  3. On the left, click the plus sign (+) to expand Customizing.
  4. Under Customizing, click Advanced Parameters.
  5. Do one of the following:
    • If you have a small number of OCCURS clauses, select Flatten OCCURS. DATABridge Client maps each occurrence of the item to a separate column in the primary table. Individual columns are named after the corresponding DMS item (using lowercase letters and converting dashes to underscores), followed by suffix "_nnn", which is the occurrence number of the item. The number includes leading zeros so that the names of all the columns have the same length.
    • If you have a large number of OCCURS clauses, select Optimize SQL updates. This option eliminates all redundant updates for the data source.