Email field getting truncated unexpectadly

[vascosoares]

Hello community,

I was experiencing truncation of the email field and, originally, I thought it could be a matter of changing the length of the field, but I since noticed that truncation is happening for emails that are nowhere near the length limit.
The truncation seems to be always happening on the ".com" part of the email by removing the "m". 

This problem was outlined in the context of an import set. Information would be loaded and then truncated, but since changing both field's length (source and target) and not seeing any change, I think it's safe to leave this context.

I can't seem to outline a pattern or find a Business Rule / Script that may be the culprit. 

Any tips?

Thanks in advance.

[shivakumarpatil]

Hi Vascosoares,
On which table is the email field getting truncated? That might help in identifying what’s causing the issue.

[Ankur Bawiskar]

@vascosoares 

share screenshots on what transform map, field map you have

may be the staging table has some field length issue and try increasing that

Also check the target field where you are planning to update has what max length

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏