How to solve the following when copying records from source to target data extension: i) query records in source data extention ordered ACS by date and ii) avoid primary key violation errors if sql activity detects 1 records with same email address?

Question

where:

The SQL activity is defied to apply updates into target data extension; those updates needs to be applied in order the inserts occurred in source data extension.

The email address in source data extension is used to generate the subscriber key value in target data extension.

All works well as long as we have just 1 record in source data extension bearing a certain e-mail address.

Jayson Morales · Answer

Hi Ana,

Sorry for the inconvenience. In case you don't receive a response here, may I also suggest joining the Maketing Cloud group below to collaborate with the experts for best practice and advice.

https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000001pQ5CAI

Hope this helps.

Regards,

Jayson

How to solve the following when copying records from source to target data extension: i) query records in source data extention ordered ACS by date and ii) avoid primary key violation errors if sql activity detects >1 records with same email address?

Data Management

Formation associée

Aide supplémentaire