-
1. Re: Query regarding Revalidate Job
Bala Gopalan Apr 5, 2021 9:52 AM (in response to Anandh S)Trust score is calculated based on the settings.
Manually updated means, did you perform direct update in the database?
-
2. Re: Query regarding Revalidate Job
Bala Gopalan Apr 5, 2021 9:53 AM (in response to Anandh S)If you execute revalidate for that particular record then it will recalculate trust and updates accordingly.
-
3. Re: Query regarding Revalidate Job
Anandh S Apr 5, 2021 10:40 AM (in response to Bala Gopalan)Yes, I have manually updated the record directly in database, since it is development environment it takes ~280 hours for revalidate job to complete successfully, so I thought of confirming before triggering it.
Also is there a way to perform revalidation for a particular record or a set of records?
I can perform recalculate for particular record/table, but I do not see any procedure or package to perform revalidation for particular record.
Since the record is directly updated in xref, I need to perform revalidation to revalidate the trust scores before recalculation.
-
4. Re: Query regarding Revalidate Job
Rahul Tiwary Apr 5, 2021 11:04 AM (in response to Anandh S)You can check below KB to
Run the Batch revalidate API for a subset of records where the records count is huge in number
-
5. Re: Query regarding Revalidate Job
Sakshi Thakur Apr 5, 2021 8:09 PM (in response to Anandh S)You should avoid using direct SQL update as the dependent tables doesn't get updated with the relevant values and it could create an issue during BVT calculation.
-
6. Re: Query regarding Revalidate Job
kunal pandit Apr 5, 2021 10:50 PM (in response to Anandh S)Did you made any changes to the validation rules recently because of which the data needs to be revalidated? Please note that revalidate job only needs to be executed when you are modifying the validation rules since the last load. If there is just data change, you do not need to execute the revalidate job at all.
In such a scenario, you just need to update the data via a regular Load Job or SIF API for it to reflect the correct trust values.
If you are facing performance issues with revalidate - you may want to tweak the multithreaded batch properties for performance improvement -
-
7. Re: Query regarding Revalidate Job
Anandh S Apr 5, 2021 11:05 PM (in response to Rahul Tiwary)Thank you for your suggestion, since this is an already existing record, the difference in count returns 0, and the dirty indicator is also 1 for this record. So is there any other way to perform revalidation for selected records only?
-
8. Re: Query regarding Revalidate Job
kunal pandit Apr 5, 2021 11:10 PM (in response to Anandh S)As per Rahul's suggestion earlier, you can use this KB# Support to basically queue a subset of records for revalidate. Instead of <rnum condition in the Query#3 for update, you can try to replace with particular rowid_object in the queries of the KB before executing revalidate.
We have not tested this, but it should work in the same way.
-
9. Re: Query regarding Revalidate Job
Anandh S Apr 5, 2021 11:46 PM (in response to kunal pandit)Hi Kunal, thank you for your suggestion. Since the record is manually updated and since it is already present in database, the first count statement is returning 0 records (No difference between BO_xref and BO_VXR, also the dirty indicator is 1)
We are using Informatica MDM 9.1 and we do not have any SIF API's.
Please confirm if this scenario will work? Though revalidation is not required if the validation needs to be performed for one single record, will it still override the trust score for the manually updated record (Decrease the trust score from 80 to 20 for a record which was marked as partially deleted manually, present trust score is 80)
-
10. Re: Query regarding Revalidate Job
kunal pandit Apr 5, 2021 11:53 PM (in response to Anandh S)hi Anandh,
Can you please confirm - "you are modifying the validation rules since the last load". If not, I will recommend that you revert the data back and send an update using the load job. This should reflect the correct trust. For 9.1, not sure if the data changes will reflect in Trust settings even after you revalidate.
You can just add a filter on the stage mapping to have only that record go thru stage and load job.
-
11. Re: Query regarding Revalidate Job
Anandh S Apr 5, 2021 11:58 PM (in response to kunal pandit)No, the validation rules remains same, I will try both revalidate and load approach and let you know the outcome.
Thank you
-
12. Re: Query regarding Revalidate Job
kunal pandit Apr 6, 2021 12:09 AM (in response to Anandh S)Yes, please execute a load job and use KB# 525128 to under revalidate job.
What you may need is to execute the recalculate BVT job for a single record - Recalculate BVT Jobs
The behavior should be same in 9.1.
-
13. Re: Query regarding Revalidate Job
Anandh S Apr 7, 2021 8:20 AM (in response to kunal pandit)Hi Kunal,
Revalidating the Address table and then running recalculate procedure have fixed the issue.
Have one question, can revalidate job be cancelled/set to incomplete status once after triggering it? Will there be any impact if we do so?
-
14. Re: Query regarding Revalidate Job
kunal pandit Apr 13, 2021 11:33 AM (in response to Anandh S)You should be able to cancel the execution but whether it will halt successfully will depend on the execution point of the job at the time. As it is an unsupported version, we do not have any references for the same at this time.