We are using Base data cleanse transform for cleansing the email address & recently business has decided to go with emails having .scot domain. Unfortunately, this email address when parsed by the transform, returns a NULL value in the output.
This means, transform is not accepting the domain.
Can anyone here suggest me the ways to allow this domain to be successfully parsed.
Also, I'm not looking for any manual solution and moreover looking for any SAP Notes or any existing solution around this.
We do not have Information steward installed to modify the existing cleansing package.
Thanks in advance,