Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

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

Using a query

Using a query

To identify bottlenecks, run the read query directly against the source database or data warehouse.
Copy the read query directly from the session log. Run the query against the source with a query tool. On Windows, you can load the result of the query in a file. On Linux, you can load the result of the query in /dev/null.
Measure the query run time and the time it takes for the query to return the first row.

0 COMMENTS

We’d like to hear from you!