Preface
Performance Tuning Overview
Target Optimization
Source Optimization
Transformation Optimization
Mapping Optimization
Partitioned Mapping Optimization
Run-time Optimization
SQL Data Service Optimization
Web Service Optimization
Connections Optimization
Data Transformation Optimization

Performance Tuning Guide

10.5.8
- 10.5.7
- 10.5.6
- 10.5

Back Next

Conditional Filters

A simple source filter on the source database can sometimes negatively impact performance because of the lack of indexes. You can use the conditional filter in the customized data object to improve performance.

Consider the following solution for conditional filter bottlenecks:

Use the conditional filter for multiple mappings that read from the same source simultaneously.: If multiple mappings read from the same source simultaneously, the conditional filter may improve performance.
However, some mappings may perform faster if you filter the source data on the source database. You can test the mapping with both the database filter and the conditional filter to determine which method improves performance.

Rename Saved Search

Table of Contents

Performance Tuning Guide

Performance Tuning Guide

Conditional Filters

Conditional Filters