Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(4 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: What is the size limit for a SQL Override in a PowerCenter mapping?
Answer

The SQL editor for SQL query overrides in a Source Qualifier or Lookup transformation can hold a maximum of 32,767 characters.
After 32767 characters the query will be truncated and no more characters can be entered.

Workaround


If a SQL override of more than 32K characters is needed do one of the following:

Create a database view

  1. Create a database view using the SQL query override.

  2. Create a source definition based on this database view.

  3. Use this new source definition as the source in the mapping.

Copy and paste the SQL override directly

  1. Create the query override in a text editor.

  2. Edit the Source Qualifier transformation.

  3. Click on properties.

  4. Delete the SQL Query (or Lookup SQL override in a Lookup transformation).

  5. Click in this field and hit the space bar so the focus is on the field and a blinking cursor appears.

     

  6. Copy the SQL from the text editor.

  7. Paste the SQL at the blinking cursor.


Use the stored procedure transformation

​ANother option would be to use a stored procedure transformation in your mapping. 

Then set the Stored Procedure Type to Target Post Load.


More Information
​There is a feature request (CR 89498) to increase the limit of character for SQL Override in a future release of PowerCenter.​

Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter 10.0
Database:
Operating System:
Other Software:

Reference

CR 89498
CR 107167


Attachments

Last Modified Date:11/16/2016 8:18 PMID:103327
People who viewed this also viewed

Feedback

Did this KB document help you?



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