Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: Can a SQL query or a source filter be used with a dynamic partitioning in a PowerCenter session?
Problem Description
Can dynamic database partitioning be used with a user defined SQL statement or a user defined source filter in the Source Qualifier?
Cause
Solution

A SQL override or a user defined SQL filter cannot be used with database partitioning and dynamic partitioning.

A feature request (CR 189703) has been created to add this functionality in a future release.

Workaround

Use a Filter transformation after the Source qualifier to add the filter conditions.

More Information
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter 8.x; PowerCenter 9.x
Database:
Operating System:
Other Software:

Reference

CR 189703

Attachments
Last Modified Date:4/11/2014 2:09 AMID:100604
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)