Preface
Performance Tuning Overview
- Performance Tuning Overview
Bottlenecks
Optimizing the Target
Optimizing the Source
Optimizing Mappings
Optimizing Transformations
Optimizing Sessions
Optimizing Grid Deployments
Optimizing the PowerCenter Components
Optimizing the System
Using Pipeline Partitions
Appendix A: Performance Counters

Performance Tuning Guide

10.5
- 10.5.8
- 10.5.7
- 10.5.6
- 10.4.0

Back Next

Using Operators Instead of Functions

The Integration Service reads expressions written with operators faster than expressions with functions. Where possible, use operators to write expressions. For example, you have the following expression that contains nested CONCAT functions:

CONCAT( CONCAT( CUSTOMERS.FIRST_NAME, ‘ ’) CUSTOMERS.LAST_NAME)

You can rewrite that expression with the || operator as follows:

CUSTOMERS.FIRST_NAME || ‘ ’ || CUSTOMERS.LAST_NAME

Rename Saved Search

Table of Contents

Performance Tuning Guide

Performance Tuning Guide

Using Operators Instead of Functions

Using Operators Instead of Functions