In reference to relational connections created in the PowerCenter Workflow Manager, which one of the following statements is true?
Select an option, then click Submit answer.
-
○
The connection environment SQL executes when a session connects to the database.
-
○
The transaction environment SQL executes Just before a COMMIT against the target.
-
○
The transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.
-
○
You can use the connection environment SQL to set folder permissions in the PowerCenter repository database.