Start a new topic
Answered

Fixing golden errors from an invalid FK column?

We have golden records that were assigned an error status because one of the FK entity columns had a value that we did not expect. We want to add that particular value as an option for that entity type and then have those golden records be successfully processed as valid. 


I wasn't sure if there was a way to reprocess the records within Semarchy, or if this would require something like reloading those records or manually authoring them.


Best Answer

Hello Danny,


Indeed, you'll need to reload those records after the parent value is rightfully processed.


Depending on the entity type, you'll need to either provide the primary key attribute (basic entity) or the SourceID and PublisherID (match entity). This way it will process as an edit.


Finally based on the loading process (SQL or REST), you'll need to consider reprocessing all attributes (SQL) or just the ones you want updated (REST).


Hope this helps.

Have a good day.

Alexia

1 Comment

Answer

Hello Danny,


Indeed, you'll need to reload those records after the parent value is rightfully processed.


Depending on the entity type, you'll need to either provide the primary key attribute (basic entity) or the SourceID and PublisherID (match entity). This way it will process as an edit.


Finally based on the loading process (SQL or REST), you'll need to consider reprocessing all attributes (SQL) or just the ones you want updated (REST).


Hope this helps.

Have a good day.

Alexia


1 person likes this
Login to post a comment