Instead split the query into three distinct components that are chained together with OnSubJobOk or OnComponentOk.

Better yet, use some of Talend's power and move the logic out of the SQL statements there and into the components. You should be able to SELECT all of the data from your ta_ref_bi table with a tMySqlInput component and then link that with a main connector to a tMySqlOutput component that is set to Drop table if exists and create in the "Action on table".