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: When is the Source Filter in the Source Qualifier applied in the PowerCenter session?
Answer

When you specify a Source Filter, the filter is added to the default SQL query as a WHERE clause and issued to the source database when the PowerCenter session initially reads the data from the source.
The filter is applied when the session reads the data at the database level and not after the data is fetched.

The query issued to the database can be found in the session log.
For example, the following is the query is issued in the source database when the source filter condition specified as SRC_IN.ID = 4

Message Code: RR_4010 
Message: SQ instance [SQ_SRC_IN] SQL Query [SELECT SRC_IN.ID, SRC_IN.NAME FROM SRC_IN WHERE SRC_IN.ID = 4]

You can also specify the entire query in the SQL Query attribute in the Source Qualifier.
This will override the default query issued to the database as well as the Source Filter condition.


More Information

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

Reference
PowerCenter Transformation Guide > "Source Qualifier Transformation" > "Entering a Source Filter"

Attachments

Last Modified Date:10/27/2009 11:14 AMID:109331
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)