Performance Tuning Guide

10.5.6
- 10.5

Back Next

Customized Data Object Optimization

You can configure customized data objects to improve performance. You can optimize the SQL query, use conditional filters, and select distinct values from the source in a customized data object.

Consider the following solutions for customized data object bottlenecks:

Create a custom query to issue a special SELECT statement for the Data Integration Service to read source data.: The custom query replaces the default query that the Data Integration Service uses to read data from sources.
Filter rows when the Data Integration Service reads source data.: If you include a filter condition, the Data Integration Service adds a WHERE clause to the default query.
Select distinct values from the source.: If you choose Select Distinct, the Data Integration Service adds a SELECT DISTINCT statement to the default SQL query.
Apply database hints.: You can add hints to the source SQL query to pass instructions to a database optimizer.

Configure constraints on source data.: If you configure constraints on flat files and relational tables in a customized data object, the Data Integration Service drops the rows that do not evaluate to TRUE for the data rows.

Rename Saved Search

Table of Contents

Performance Tuning Guide

Performance Tuning Guide

Customized Data Object Optimization

Customized Data Object Optimization