When you clean stop a task enabled for

SQL ELT optimization

and the target or source properties in the mapping contains SQL statements, all the SQL statements in progress are attempted to be reverted. All SQL statements that are committed cannot be reverted.

When you run a mapping configured to create a new target at runtime and clean stop the job immediately, Data Integration creates the target table even if the job is terminated.