Data not entering into DataExtension

Question

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?

Answer 1

I typically import SF Reports into staging Data Extension and then use a Staging-to-Master Query Activity to handle data transformations. In most cases, I just accept the default field precisions in the Import Activity.

Something like this will save you a lot of trouble:

select
 case 
   when len(s.email) > 100 then left(s.email,100) 
   else s.email 
 end as email
 , s.SubscriptionDueDate
from StagingDataExtension s
/* target MasterDataExtension */
/* action: update */