With the direct/simple execution strategy, all extraction, transformation, and loading happens in a single database. When the Best Fit option is enabled, Data Integrator uses this strategy under the following conditions:
All source tables and target tables reside in the same database.
No Java operators are used.
The data validation condition is not used.