3.21 Optimizing Flat File Sources

  • If each line in the source file is less than the default setting (1024 Bytes per line), you can decrease the line sequential buffer length in the session properties
  • Configuring Single-Pass Reading: Consider using single-pass reading if you have multiple sessions that use the same sources
  • Optimizing Filters: Use Filter Conditions as early in the mapping as possible