I am trying to create and perform a QueryActivity through the SOAP API. I managed to get it working using 'Overwrite' as the value for the TargetUpdateType attribute.
However I cannot find any documentation on allowed values for this field. To tell you the truth I am not really sure what 'Overwrite' does.
Does anybody know what the possible values and their effect is?
Attribution to: user7646
Possible Suggestion/Solution #1
The possible values are:
Overwrite : truncates target DE, and puts the results of the query in.
Append : adds new values to DE, but does not update records. Requires a primary key on the DE.
Update : adds new values to DE and updates records as needed. Requires a primary key on the DE.
Hope this helps.
Attribution to: Timothy
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/31517