Can anyone help me out why the automation is failing? If I'm using Overwrite activity and query work perfectly.
When I'm trying to update the target DE it is failing. below is my query.
SELECT a.EmailAddress, a.FirstName, a.LastName, a.Gender, a.Hunting, a.DrawingPainting, a.Hiking, a.State, a.EmailOptin, a.EmailOptinDate, a.EmailOptoutDate, a.RegistrationSource, a.Country, b.Mens, b.Womens, b.Kids, b.EmailOptDown FROM Master_Subscribers_Active a INNER JOIN Preference_Changelog b ON a.EmailAddress = b.EmailAddress WHERE a.EmailOptin = 'True' AND b.EmailOptin = 'True' AND b.EmailOptDown = 'True'