In reference to relational connections created in the PowerCenter Workflow Manager, which one of the following statements is true?
A) The connection environment SQL executes when a session connects to the database.
B) The transaction environment SQL executes Just before a COMMIT against the target.
C) The transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.
D) You can use the connection environment SQL to set folder permissions in the PowerCenter repository database.

Question

Quizplus · Accepted Answer

The connection environment SQL executes when a session connects to the database, allowing for initial setup or configuration needed for the session's database operations.

In Reference to Relational Connections Created in the PowerCenter Workflow