Skip to main content
Solved

Overrides on records in OGC


Forum|alt.badge.img+1

Records marked as match_override after being fixed on OGC. When the matching rules changed and subject is reprocessed, these records are being unchanged while they are supposed to match with other records. How do we [omnihealthdata].[dbo].[ids_override_match] and [omnihealthdata].[dbo].[ids_override_property] tables contain these records, did try deleting from these table and rebuild and reprocess with the new match rules but they would not match.

Best answer by Ales

Hi @sgilla, the Manual Override step can be part of  a different workflow. I believe the DB tables represent just a source for further pre-process.

If there are manual override enabled the process might look like this:

  1. add your overrides to your DB table - input user interface
  2. run a process to apply overrides - uses the Manual Override Builder step
  3. run standard data processing to match the date using standard rules + considering manual overrides as well.
View original
Did this topic help you find an answer to your question?

6 replies

Forum|alt.badge.img+1
  • Author
  • Data Pioneer
  • 36 replies
  • August 19, 2024

@Ales This is the question I was referring to. Thank you.


Ales
Ataccamer
Forum|alt.badge.img+2
  • Ataccamer
  • 27 replies
  • August 21, 2024

@sgilla I’m afraid this is specific custom part of the OMNI solution where I do not have much visibility to. 

In general Ataccama Matching can accept overrides - typically an external source (file/table) containing the required overrides. This is probably your [ids_override_match].

If you delete such overrides the matching SHOULD simply not consider any override in the process and SHOULD match using standard matching rules HOWEVER there must be another step enabled somewhere in your solution - Manual Override Builder. This STEP allows you to rebuild the repo with the override inputs.

I know this is probably not giving you the ultimate answer however you may check if the whole process has all required components in place first.

 


Forum|alt.badge.img+1
  • Author
  • Data Pioneer
  • 36 replies
  • August 21, 2024

@Ales  thank you for a direction, i will look into it. 


Forum|alt.badge.img+1
  • Author
  • Data Pioneer
  • 36 replies
  • August 22, 2024

There is no manual override that was found on the component. The records match when the override_match (one of the match rules) is edited to remove the white list. But they get added back even though the records have been removed from the override table. There should be another table I am missing? I checked all the ticket tables to find any traces but none found. 


Ales
Ataccamer
Forum|alt.badge.img+2
  • Ataccamer
  • 27 replies
  • Answer
  • August 23, 2024

Hi @sgilla, the Manual Override step can be part of  a different workflow. I believe the DB tables represent just a source for further pre-process.

If there are manual override enabled the process might look like this:

  1. add your overrides to your DB table - input user interface
  2. run a process to apply overrides - uses the Manual Override Builder step
  3. run standard data processing to match the date using standard rules + considering manual overrides as well.

Forum|alt.badge.img+1
  • Author
  • Data Pioneer
  • 36 replies
  • August 28, 2024

@Ales  I confirm in my case [omnihealthdata].[dbo].[ids_override_match]  is the table. It was a little tricky to find the related records, i should go by the master id and not just the instance id. Thank you for the help in pointing me back to the table. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings