•  Data Integration performance tuning overview
  •  Best practices
    •  Secure Agent and cloud regions
    •  Secure Agent machines
    •  Secure Agent upgrades
    •  SQL ELT optimization
    •  Cloud connector performance
    •  Mapping design and environment
  •  Bottlenecks
    •  Thread statistics
•  Optimizing targets
  •  Identifying target bottlenecks
  •  Eliminating target bottlenecks
•  Optimizing sources
  •  Identifying Source Bottlenecks
    •  Using a Filter transformation
    •  Using a read test mapping
    •  Using a query
  •  Eliminating source bottlenecks
•  Optimizing mappings
  •  Identifying mapping bottlenecks
  •  Eliminating mapping bottlenecks
  •  Optimizing delimited flat file sources
  •  Optimizing data preview
  •  Optimizing filters
  •  Optimizing data type conversions
  •  Optimizing expressions
    •  Factoring out common logic
    •  Minimizing aggregate function calls
    •  Replacing common expressions with local variables
    •  Choosing numeric instead of string operations
    •  Choosing DECODE instead of LOOKUP
    •  Using operators instead of functions
    •  Optimizing IIF functions
    •  Optimizing window functions
    •  Evaluating expressions
  •  Optimizing Aggregator transformations
    •  Grouping by simple columns
    •  Using sorted input
    •  Filtering data before you aggregate
    •  Limiting connected fields
  •  Optimizing Hierarchy Processor transformations
  •  Optimizing Joiner transformations
  •  Optimizing Lookup transformations
    •  Caching lookup tables
    •  Optimizing the lookup condition
    •  Filtering lookup rows
    •  Indexing the lookup table
    •  Optimizing multiple lookups
  •  Optimizing Machine Learning transformations
  •  Optimizing Normalizer transformations
  •  Optimizing Router transformations
  •  Optimizing Sequence Generator transformations
  •  Optimizing Sorter transformations
    •  Allocating memory
    •  Specifying a work directory
•  Optimizing mapping tasks
  •  Identifying mapping task bottlenecks
  •  Eliminating mapping task bottlenecks
    •  Buffer memory
    •  Caches
    •  Verbose logs
  •  Best practices in advanced mode
•  Optimizing advanced clusters
  •  Advanced cluster components
  •  Best practices
  •  Optimizing advanced cluster nodes
    •  Optimizing master nodes
    •  Optimizing worker nodes
  •  Optimizing instance types
    •  Using GPU instances
    •  Using Graviton instances
    •  Using AMD chipsets
•  Optimizing system performance
  •  Identifying system bottlenecks
    •  Identifying system bottlenecks on Windows
    •  Identifying system bottlenecks on Linux
  •  Eliminating system bottlenecks

Data Integration performance tuning overview

Eliminating system bottlenecks

HL_SecureAgentSizingAdvanced