Need

In some use cases, it is needed to update one or multiple attributes of a fuzzy entity. But directly at golden level, without reprocessing one or multiple masters and going through the certification process.


Summarized Solution

The general idea is to "mimic" an authoring done in the UI but via SQL.


Detailed Solution

  • Create a new survivorship rule specifically for the attributes you want to bypass the certification process. This will allow those attributes to be overridden in its consolidation strategy.
  • Create a specific job that will process the attributes in the entity.
  • You can then run this query to load data into the source authoring table:
Insert into SA_XX (B_LOADID, <GOLDEN_ID_COLUMN>, B_AUTHORING_TYPE, B_CLASSNAME, <COLUMNS_TO_OVERRIDE>) values (vLoadid, <the golden id to override>, <'OVERRIDE' or 'DATA_ENTRY'>, <your_entity_name>, <the new values for the columns to override>)
Plaintext
  • Run this query into the SF table. SF_<Physical Table Name>, stores flags that indicate which field was overridden.
Insert into SF_XX (B_LOADID, B_CLASSNAME, <GOLDEN_ID_COLUMN>, <COLUMNS_TO_OVERRIDE>) values (vLoadid, <your_entity_name>, <the golden id to override>, <flag '1' for each column that needs to be overridden>)
Plaintext