Data Source Indexes

When multiple data sources are joined in an import, and if the load sizes are huge, that is, 200 K, configuring indexes for data sources is helpful.

Indexes are created on the Data File (DF) tables for bulk loading scenarios.

Create the index file under: $MQ_COMMON_DIR\enterpriseinternalname\datasource\datasourcename.idx.Filename must match to the data source name. Indexes are created only when uploading data source. Therefore, files must be created before the actual upload.

• Example 1

  If the CID column of the DF_33969_37793_TAB data source table is mapped to PRODUCTID; and not mapped to PRODUCTIDEXT, create an index file as UPPER("CID")

• Example 2

  If the CID column of the DF_33969_37793_TAB data source table is mapped to PRODUCTID, and CEXT is mapped to PRODUCTIDEXT, create an index file as UPPER("CID"),UPPER("CEXT")

Copyright © Cloud Software Group, Inc. All rights reserved.