When you create a SQL transformation, you can configure the SQL transformation to run in passive mode instead of active mode. A passive transformation does not change the number of rows that pass through it. It maintains transaction boundaries, and maintains row types.
If you configure the transformation to run in Query mode, you can configure passive mode when you create the transformation. You cannot change the mode after you create the transformation.