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
A
Alexia SIMOND
said
over 1 year ago
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
A
Alexia SIMOND
said
over 1 year ago
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).
Danny ACKROYD
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.
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
Alexia SIMOND
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
-
Recreate a dev environment. Any side effect?
-
Can you help me configure my REST Client Response Output Value Selector?
-
Is Tomcat Manager Accessible Remotely
-
Cleaning mta_task_def
-
Drop tables within the datalocation schema
-
Which REST API that can be used for "Deploy Model Edition" ?
-
Session timeout settings
-
Audit logs in Semarchy
-
Automatic Deployment
-
Error while creating Model from API
See all 49 topics