The SQL Selector operator takes a checkpoint only when all of the data is sent to the Teradata PT data stream.
Then, on restart, the operator either sends none of the data, all of the data, or terminates with an error message, depending on the status of the data:
- If all of the data is sent, then the operator displays the following message and does not resend any of the data:
Restart indicates that this export job completed.
- If all of the data is not sent, then the operator terminates. Restart the job from the beginning.
- If none of the data is sent, then the operator sends the data.