Configuring an Object for Detailed Consolidation Statistics

You can configure an object to obtain detailed consolidation statistics during a consolidation-enabled data load process. This configuration enables OneData to generate a unique identifier for records added or modified during data consolidation.

To configure an object for detailed consolidation statistics

1. On the Menu toolbar, click Define > Objects, and select the object to configure.

2. Click Add Column and add a VARCHAR column of 255-character length.

For more details on how to add columns to an object, see Implementing webMethods OneData.

3. Navigate back to the object definition screen.

4. Under Additional Qualifiers, set the Data Load Identifier value for the new column you added.

For details on the Additional Qualifiers, see Implementing webMethods OneData.

5. Save the modified object.

Result: During a consolidation-enabled data load process, OneData generates a unique identifier for the data load as a sequence number in the format Date_DB_sequence_number. For example, 2020-01-11_99. If this qualifier is configured, during the import process, a detailed bifurcated count of records imported/updated into consolidation and consolidation gold table is available as a part of import message. You can also use this unique identifier to filter for records that were added or modified in the object as part of a single import.

The SVC logs include the unique identifier as Data Load Identifier.

For details on the unique data load identifier in the data import process , see Defining Interchange Mappings to Load Data from External Sources to the Consolidation (Staging) Object.