I have imported Contact Object field from Sales Cloud via Import Activity into the Marketing Cloud. While trying to import contact Email field (Standard Contact email field) it is displayed as Text. I changed it to type Email. On changing the type it defaults to length 100.
Further, I want to populate this Contact Email field into other data extension via Query activity. When i try to create a target data extension and add a field Email with type equal to Email it defaults to 255.
As there is a mismatch between the source data extension field length [Email: length 100]
and target data extension field length [Email: length 254]
, my query fails to insert email field into the target data extension. Any solution to overcome this?