Problem
The Preferred Publisher is ignored when I have it set up on record level consolidation (this would also apply to field level consolidation too).
I have 3 files from 3 sources. There are suplicates across these sources and I want to consolidate at record level based on e Preferred Publisher.
My Preferred Publisher's and their order are as follows:
- SystemA
- SystemB
- SYSTEMC
When I load data through the hub, the golden record is being created from SYSTEMC. Why is my Preferred Publisher order being ignored?
Solution
When you set up a Preferred Publisher in MDM, please note that Oracle creates the physical code (Publisher code) in upper case. Therefore, in this example the Publisher Code for SystemA is SYSTEMA, and for SystemB is SYSTEMB.
You must therefore make sure in your DI jobs, that you use upper case values for B_PUBID, otherwise the publisher is seen to be unknown. In this example SYSTEMC was in upper case so was accepted as the first valid publisher in the Preferred Publisher list (SystemA and SystemB were not recognised).
Related articles