The PowerCenter Integration Service extracts data from EIM tables based on each unique combination of the EIM table name and the batch number specified in the CONTROL_FIELDS input group. The naming convention for each port is <group name>_<field name>. The CONTROL_FIELDS group contains the following ports:

The PowerCenter Integration Service retrieves the EIM table name and the batch number from a source that is linked to the CONTROL_FIELDS group. You can filter rows by specifying particular batch numbers and EIM tables in the control fields.

If a flat file provides values for the CONTROL_FIELDS group, the flat file header must contain the EIM table name and the batch number in the following format:

The PowerCenter Integration Service extracts data from an EIM table for each batch number specified in this group. If the specified batch number does not match a batch number in the EIM table, the PowerCenter Integration Service ignores that batch for session performance. If the source does not provide an EIM table name or batch number, the PowerCenter Integration Service does not extract data for any EIM table.

The following table shows an example EIM table, EIM_ACCNT_CUT:

The following table describes the CONTROL_FIELDS group:

The PowerCenter Integration Service extracts data only for batch number 2 because the CONTROL_FIELDS group does not contain the batch number 1 for the EIM_ACCNT_CUT EIM table.