By default, sessions run on a single thread. To leverage multi-core CPUs, enable partitioning.

Security is the primary driver for many 10.6 upgrades. This version introduced significant enhancements to authentication protocols:

| Capability | Benefit | |------------|---------| | Schema drift handling | New columns in a CSV or relational source are automatically passed through or routed | | Dynamic lookups | Lookup condition can change based on incoming metadata | | Dynamic target loading | Automatically creates/alters target table schema (with appropriate permissions) | | Reusable dynamic mappings | One mapping pattern handles hundreds of source file formats |