I've got a general question on the order of execution with regards to the generated PROC SQL in an Oracle Bulk Loader transformation. While I have examined the generated code in question, I am no expert at the base code and would prefer a better explanation if possible.   Here's what I'm trying to understand: I'm looking to use the bulk load transformation with the "Drop and recreated indexes" option enabled. Furthermore, I'm considering adding a snippet of code to the Pre-code portion of the transformation.   What will be the order in which these items execute? Will the DROP INDEX execute first, prior to any other actions in the code? Or does the Pre-code section take precedent? ... View more