Phone and Email Validation Issues & Solutions

For phone and Email validation Please follow below steps in following sequence

1. Please check the phone number/Email in the cloud tracker tables.
2. If you don't find any record in tracker table, you can check with Informatica. If it is valid, you can ask user to directly add from portal. If it is invalid, Please ask user to provide valid number.
3. If you find the record in tracker table where it is invalid and informatica shows it as valid then the Phone/Email should be validated manually.

How do we validate manually --> We update the Phone/Email record in the corresponding tracker table with column is_validated='Y'

Tracker Table names:

1. mdm_smdsmd.phone_validation_tracker
2. mdm_smdsmd.email_validation_tracker

Query to check:

select * from mdm_smdsmd.email_validation_tracker evt where email_id = 'email@ymail.com'

select * from mdm_smdsmd.phone_validation_tracker pvt where pvt.phone_num = '2122707000'

Note:

If the number/email is valid and you can’t find any entry in tracker table and if user raises concern that CMD shows as invalid, then please communicate this to user. After entering communication number/email, ask them to click out of the textbox.