Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Print Bookmark Alert me when this article is updated


HOW TO: Determine when to use quotes strings inside an Expression transformation and Lookup SQL override

In Expression Transformation, you should not use quote for mapping parameters/ variables and use quote for strings because mapping parameters/variables needs to be expanded by Integration service.


REPLACESTR (0, SNAME, 'tel3', $$TARGET_SYSTEM||'tel3')

In above example, the mapping parameter and variable like $$TARGET_SYSTEM should not be within quotes and string like tel3 should be within quotes.

In a Lookup transformation, you should quote strings, Mapping parameters/Variables and not the Database reserved words. The Lookup override is sent to database and database server does no understand mapping parameters/variables (since they are PowerCenter reserved words.)


SELECT price1, price2 FROM WHERE Date BETWEEN '$$BeginBillDate' AND '$$EndBillDate'

In the above example, you should not quote Database reserved words like BETWEEN, WHERE and quote mapping variables like $$BeginBillDate.

More Information

Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter 7.1.x; PowerCenter 8.1.x; PowerCenter 8.5; PowerCenter 8.5.1; PowerCenter 8.6; PowerCenter 8.6.1
Operating System:
Other Software:



Last Modified Date:8/28/2009 11:56 AMID:23079
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)