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 tables in different databases be used in a Source Qualifier transformation?
Answer
Sources from two databases of the same type database type (and with the same connection information), can be joined in one Source Qualifier using SQL join syntax.
If the two databases are of different types, (Example: Oracle and DB2) then they cannot be joined in a Source Qualifier. This includes any two tables that require different relational connections in the session (even if they are of the same database type).

If each table uses a different relation connection then each table must be added to the mapping as a Source Definition and each Source Qualifier can then be joined using a Joiner transformation.


More Information

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

Reference
"Joining Source Data" in the "Source Qualifier Transformation" chapter of the PowerCenterTransformation Guide.
"Joiner Transformation Overview" in the "Joiner Transformation" chapter of the PowerCenterTransformation Guide.

Attachments

Last Modified Date:12/21/2010 3:09 AMID:17657
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)