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.6
- 10.5
- 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

Optimizing Expressions

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Performance Tuning Guide

Performance Tuning Guide

Using Operators Instead of Functions

Using Operators Instead of Functions