We have a requirement to get below data statistics for each load
1. No. of new records
2. No. of updates
3. No. of merges
4. No. of duplicate/suggestion tasks created
Am looking if there are any standard options available in Semarchy to get these at the end of the load.
Would be great if you could share any inputs on the same. Thanks in advance!
Thanks,
Vinoth
Best Answer
A
Alexia SIMOND
said
3 months ago
Hello Vinoth,
Indeed, some numbers are present in the job logs, but those are technical statistics on the actions made on the DB to process the certification. So 1 creation there does not equate to a record creation.
Hence why to have proper records statistics, you'll need to directly query the data location and/or repository based on your need.
To the extent of my knowledge those "statistics" are not stored in our solution.
However everything is stored either in the data location or the repository.
So querying those schemas with the right requests should help you compute those numbers.
And could be available in a dashboard for example.
V
Vinoth KUMAR C
said
3 months ago
Hi Alexia,
Thanks for the response.
We are querying the data/history tables to get the details for now, I was wondering if anything available within the product that can be used. We can see the job logs giving the total insert/update/delete counts for the entire job or task, but they are not the actual stats on data that we are looking for.
A
Alexia SIMOND
said
3 months ago
Answer
Hello Vinoth,
Indeed, some numbers are present in the job logs, but those are technical statistics on the actions made on the DB to process the certification. So 1 creation there does not equate to a record creation.
Hence why to have proper records statistics, you'll need to directly query the data location and/or repository based on your need.
Vinoth KUMAR C
Hi All,
We have a requirement to get below data statistics for each load
1. No. of new records
2. No. of updates
3. No. of merges
4. No. of duplicate/suggestion tasks created
Am looking if there are any standard options available in Semarchy to get these at the end of the load.
Would be great if you could share any inputs on the same. Thanks in advance!
Thanks,
Vinoth
Hello Vinoth,
Indeed, some numbers are present in the job logs, but those are technical statistics on the actions made on the DB to process the certification. So 1 creation there does not equate to a record creation.
Hence why to have proper records statistics, you'll need to directly query the data location and/or repository based on your need.
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstAlexia SIMOND
Hello Vinoth,
To the extent of my knowledge those "statistics" are not stored in our solution.
However everything is stored either in the data location or the repository.
So querying those schemas with the right requests should help you compute those numbers.
And could be available in a dashboard for example.
Vinoth KUMAR C
Hi Alexia,
Thanks for the response.
We are querying the data/history tables to get the details for now, I was wondering if anything available within the product that can be used. We can see the job logs giving the total insert/update/delete counts for the entire job or task, but they are not the actual stats on data that we are looking for.
Alexia SIMOND
Hello Vinoth,
Indeed, some numbers are present in the job logs, but those are technical statistics on the actions made on the DB to process the certification. So 1 creation there does not equate to a record creation.
Hence why to have proper records statistics, you'll need to directly query the data location and/or repository based on your need.
-
Can we reset Matches and run again on match rule change or add a new match rule?
-
"Unmerge" records
-
Turn off match rules to speed up an integration job
-
Can anyone tell me how to load a Fuzzy-Matched entity ... but skip the matching happening auto-magically?
-
Importing CSV in Fuzzy Matched Entity Does Not Trigger Consolidation
-
How can I trigger a "match on child records"?
-
How can I Configure Most Frequent Values in Survivorship Rules?
-
Deterministic or probabilistic matching
-
Machine Learning and AI for matching
-
Prevent loads from replacing values overridden by users
See all 55 topics