Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Problem

When loading data into the hub, a given publisher seems to be ignored in record-level or field-level consolidation in Convergence for MDM.
This publisher is used either in a Preferred Publisher or in Custom Ranking consolidation strategy.

Solution

The value stored and expected by Convergence for MDM to identify the publisher of a record is the Publisher Code, and not its Name. The code, unlike then name is always in UPPERCASE.

There are several reasons for a preferred publisher to be ignored in a consolidation:

  • The Data loaded in the SD_ table do not use the Publisher Code in the B_PUBID column. This publisher code must be loaded in UPPERCASE.
    If the value in B_PUBID does not match an existing publisher code, then this publisher is considered at the last position in the preferred publisher consolidation. Other publishers' values will always be taken into account for consolidation.
  • When the PublisherID built-in attribute used in a Custom Ranking consolidation, then the literal values specified in the SemQL expression should be equal to the Publisher Code. These values are also in UPPERCASE.
    If the SemQL clause does not contain literal that match exactly  the publisher codes, then the clause will never work as expected.

 

  • No labels