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: Does Pre-SQL use an Oracle session that is different than the select statement used in the Source Qualifier?
Answer

According to PowerCenter design, when a Pre-SQL is configured in a session, PowerCenter first executes the Pre-SQL command using the source database connection. Then, it opens a new connection for the source and executes the Source Qualifier query.

If the requirement is to use the same source database connection (which is working as expected) and the same Oracle session, then you can use the Environment SQL option in the source relational database connection. The Integration Service runs the connection environment SQL each time it connects to the database. You can configure a SQL which will keep the Oracle session in sync each time it connects to the source database. The necessary SQL command to give in Environment SQL will retain the same Oracle session.


More Information

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

Reference

Attachments

Last Modified Date:11/6/2019 3:43 PMID:31292
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)