Available Options to Check Data Quality for Item Batches

You can specify data quality options when defining a source system or through an import batch definition by selecting Check data quality on upload.

Items being created in the Oracle Product Hub go through the data quality check automatically, while items that are updated using batches must have the data quality check initiated manually. The cleansing process classifies the item, standardizes the attributes and identifies any matches or duplicates that may exist in the product hub.

Check Data Quality Options

The options that are available when you select the Check data quality on upload option are determined by the data source.

• If the items are being created or updated from a third-party source system, then the following options are available:

  • Enable data quality matching

  • Confirm single matches

  • Confirm unmatched as new item

• If the items are being created or updated in Oracle Product Hub, then the following options are available:

  • Enable data quality matching

  • Confirm unmatched as new item

Note: In the Product Information Management work area, Oracle Product Hub is represented as a spoke system with the name Product Information Management Data Hub.

Enable Data Quality Matching

You can improve item data import performance and reduce the time needed for initial data load and data migration by modifying the behavior of data quality matching.

The Enable data quality matching option enables you to control whether the process associated with identifying potential duplicates in the import is run or not. By deselecting this option, you can improve the import performance in cases where the data is already known to be good. This can be selectively done for each batch.

• Use this option to control whether data quality matching has to run to identify potential duplicates in an import. Depending on the known state of your data, it might not be necessary to identify potential duplicates.

• Deselect this option to ignore the process associated with matching for your imports.

• Deselect this option to improve import performance when you don't want data quality checks to be performed.

• This option is especially useful for an initial data load when the data is already de-duplicated outside Product Hub.

Confirm Single Matches

The behavior of the Confirm single matches data quality option is determined by the data source.

• If items are being created from a third-party source system and are imported manually, the following behavior results:

  • Single matches appear in the In Progress tab and the edit match actions value is Confirm.

  • Multiple or no matches appear in the In Progress tab and the edit match actions value is Unconfirm.

  • If Confirm Single Matches isn't selected, then all items will appear in the In Progress tab and the edit match actions value is Unconfirm.

• If items are being created from a third-party source system and are imported during data load, the following behavior results:

  • Single matches appear on the Imported tab.

  • Multiple or no matches appear in the In Progress tab and the edit match actions value is Unconfirm.

  • If Confirm Single Matches isn't selected, then all items will appear in the In Progress tab and the edit match actions value is Unconfirm.

• If items are being updated from a third-party source system and are imported manually, the following behavior results:

  • If a cross-reference exists, then no data quality check is performed, and the items appear in the In Progress tab and the edit match actions value is Confirm.

  • If Confirm Single Matches isn't selected, a cross-reference exists, and no data quality check is performed, then the items appear in the In Progress tab and the edit match actions value is Confirm.

• If items are being updated from a third-party source system and imported during data load, the following behavior results:

  • If a cross-reference exists, then no data quality check is performed, and the items appear on the Completed tab.

  • If Confirm Single Matches isn't selected, a cross-reference exists, and no data quality check is performed, then the items appear on the Completed tab.

Confirm Unmatched As New Item

The behavior of the Confirm unmatched as new item data quality option is determined by the data source.

• If items are being created from a third-party source system and imported manually, the following behavior results:

  • Items with no matches appear in the In Progress tab and the edit match actions value is Confirm.

  • Items with single or multiple matches appear in the In Progress tab and the edit match actions value is Unconfirm.

  • If Confirm unmatched as new item isn't selected then all items will appear in the In Progress tab and the edit match actions value is Unconfirm.

• If items are being created from a third-party source system and imported during data load, the following behavior results:

  • Items with no matches appear on the Completed tab

  • Items with single or multiple matches appear in the In Progress tab and the edit match actions value is Unconfirm.

  • If Confirm unmatched as new item isn't selected then all items will appear in the In Progress tab and the edit match actions value is Unconfirm.

• If items are being updated from a third-party source system and imported manually, the following behavior results:

  • If a cross-reference exists, then no data quality check is performed and the items appear in the In Progress tab and the edit match actions value is Confirm.

  • If Confirm unmatched as new item isn't selected then and a cross-reference exists, no data quality check is performed and the items appear in the In Progress tab and the edit match actions value is Confirm.

• If items are being updated from a third- party source system and imported during data load, the following behavior results:

  • If a cross-reference exists, then no data quality check is performed and the items appear on the Import tab.

  • If Confirm unmatched as new item isn't selected then, if a cross-reference exists, no data quality check is performed and the items appear on the Import tab.

• If items are being created or updated from the Product Data Hub and imported during data load, the following behavior results:

  • Items with no matches appear on the Import tab.

  • Items with single or multiple matches appear in the In Progress tab and the edit match actions value is Unconfirm.

  • If Confirm unmatched as new item isn't selected then all items will appear in the In Progress tab and the edit match actions value is Unconfirm.

• If items are being created or updated from the Product Data Hub and imported manually, the following behavior results:

  • Items with no matches, single matches, or multiple matches appear in the In Progress tab and the edit match actions value is Unconfirm.