A customer provides a file containing only new and updated subscriber records exported from its marketing database.
* The file will be uploaded to the customer's Enhanced FTP automatically at 3AM daily.
* The customer requires that the import completes prior to 4AM.
* On average, the file will contain about 2 million rows of data each day.
Based on the customer's requirements and recommended best practices, how should the daily file be imported?

Question

A customer provides a file containing only new and updated subscriber records exported from its marketing database.

* The file will be uploaded to the customer's Enhanced FTP automatically at 3AM daily.

* The customer requires that the import completes prior to 4AM.

* On average, the file will contain about 2 million rows of data each day.

Based on the customer's requirements and recommended best practices, how should the daily file be imported?

Ankitkumar Pandya · Accepted Answer

Import the file to a data extension, using the 'add and update' method.

Ankitkumar Pandya · Answer

Import the file to a list, using the 'update only' method.

Ankitkumar Pandya · Answer

Import the file to a list, using the 'add and update' method.

Ankitkumar Pandya · Answer

Import the file to a data extension, using the 'overwrite' method.

List of questions