Table of Contents

Search

  1. Preface
  2. Data Integration performance tuning overview
  3. Optimizing targets
  4. Optimizing sources
  5. Optimizing mappings
  6. Optimizing mapping tasks
  7. Optimizing advanced clusters
  8. Optimizing system performance

Data Integration Performance Tuning

Data Integration Performance Tuning

SQL ELT optimization

SQL ELT optimization

For a cloud data lake to cloud data warehouse integration,
Data Integration
intelligently identifies the opportunities to leverage cloud ecosystem or cloud data warehouse APIs for data pipeline processing.
Using SQL ELT optimization,
Data Integration
pushes the processing down to the cloud ecosystems or cloud data warehouses. This improves the data processing performance as data is processed close to the source and saves your company data transfer costs.
Data Integration
supports full SQL ELT optimization for cloud data warehouse to cloud data warehouse integrations.
Data Integration
converts mapping logic to equivalent, optimized SQL queries that the cloud data warehouse executes, without data transfers that would normally incur additional processing time and data transfer charges.
Data Integration
uses the cloud data warehouse's compute capacity to process the data without additional resources, thus achieving compute efficiency.
Try to use SQL ELT optimization for cloud data lake to cloud data warehouse or cloud data warehouse to cloud data warehouse integrations whenever SQL ELT optimization is supported.

0 COMMENTS

We’d like to hear from you!