I've recently completed an IP warming process. Contacts were being added to a new Data Extension before each send to keep track of the the separate imports throughout the migration.
Now I would like to combine all of the separate import DEs into one main Subscriber Data Extension, as well as one main Suppression Data extension for all the unsubscribes/bounced email addresses from the old system. I'm pretty new to SQL, so I'm wondering first off, is this a good approach?
Also, I'm wondering about the following scenarios:
All of the imports SHOULD have a unique list of email addresses, but what happens if they don't? I'm assuming that if an email address exists on multiple Data Extensions, it will likely be listed multiple times in the final Subscriber DE. How could I avoid this to only include one instance of each email address.
Should a query be written for each DE, to add is to the master subscriber DE one by one, or would it make more sense to pull everything at one time? (There are about 10 DEs). Are there resources available that explain how to approach this?
Can I populate a DE attribute value with SQL? For instance, if I wanted to tag one of the DEs, how could I go about creating a new attribute, and then populating that attribute for all records on the DE with "Sweepstakes-X" for instance.
Thanks in advance for any assistance with this!