Creation of Indexes for Data Sources for Database Loader

The Database Loader is primarily designed for initial data load and it does not validate data.

To ensure that data is clean before uploading it, use Data Quality and ETL tools to process the data file and clean it before uploading the data.

To quickly load larger data greater than 50K that join more than one datasource create indexes for the datasources. To do this, create the file $MQ_COMMON_DIR\<enterprise internal name>\datasource\datasourcename.idx.

Example 1

If the CID column of the data source DF_33969_37793_TAB table is mapped to productid and productidext is not mapped, create the index file as follows:

UPPER("CID")

Example 2

If the CID column of data source DF_33969_37793_TAB table is mapped to productid and CEXT is mapped to productidext, create the index file as follows:

UPPER("CID"),UPPER("CEXT")

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