Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Informatica Exam PR000007 Topic 1 Question 100 Discussion

Actual exam question for Informatica's PR000007 exam
Question #: 100
Topic #: 1
[All PR000007 Questions]

In reference to relational connections created in the PowerCenter Workflow Manager, which one of the following statements is true?

Show Suggested Answer Hide Answer
Suggested Answer: A

http://www.info-etl.com/course-materials/tips-power-center-9

by Theodora at Sep 18, 2024, 09:43 PM

Limited Time Offer

25%

Off

Get Premium PR000007 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Joaquin
7 months ago
I'm not sure, but I think option B) The transaction environment SQL executes just before a COMMIT against the target, could also be correct.
upvoted 0 times
...
Mari
7 months ago
I bet the person who wrote this question was feeling pretty Workflow-y when they came up with it.
upvoted 0 times
...
Laurena
7 months ago
I'm just hoping the exam doesn't ask me to draw a PowerCenter workflow from memory. That would be a real Connector-tration test!
upvoted 0 times
Aleisha
6 months ago
D) You can use the connection environment SQL to set folder permissions in the PowerCenter repository database.
upvoted 0 times
...
Shenika
6 months ago
C) The transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.
upvoted 0 times
...
Xuan
6 months ago
B) The transaction environment SQL executes Just before a COMMIT against the target.
upvoted 0 times
...
Levi
6 months ago
A) The connection environment SQL executes when a session connects to the database.
upvoted 0 times
...
...
Xochitl
7 months ago
A sounds like it's describing the connection environment, but I'm not sure if that's the correct answer.
upvoted 0 times
Son
6 months ago
C) The transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.
upvoted 0 times
...
Arlie
6 months ago
B) The transaction environment SQL executes Just before a COMMIT against the target.
upvoted 0 times
...
Rikki
6 months ago
A) The connection environment SQL executes when a session connects to the database.
upvoted 0 times
...
...
Sylvia
7 months ago
C is a bit confusing. Why would the transaction environment SQL cause PowerCenter to ignore the Transaction Control Transformation?
upvoted 0 times
Dean
6 months ago
D) You can use the connection environment SQL to set folder permissions in the PowerCenter repository database.
upvoted 0 times
...
Candida
6 months ago
C) I think it's because the transaction environment SQL overrides the Transaction Control Transformation.
upvoted 0 times
...
Graciela
6 months ago
B) The transaction environment SQL executes Just before a COMMIT against the target.
upvoted 0 times
...
Janey
6 months ago
A) The connection environment SQL executes when a session connects to the database.
upvoted 0 times
...
...
Angelyn
7 months ago
D seems interesting, but I'm not sure if you can use the connection environment SQL to set folder permissions in the repository.
upvoted 0 times
...
Thersa
7 months ago
I think the answer is B. The transaction environment SQL executes just before a COMMIT against the target database.
upvoted 0 times
Alyssa
7 months ago
B) The transaction environment SQL executes just before a COMMIT against the target.
upvoted 0 times
...
Katie
7 months ago
A) The connection environment SQL executes when a session connects to the database.
upvoted 0 times
...
...
Marti
7 months ago
I agree with Refugia, because the connection environment SQL is executed when the session connects to the database.
upvoted 0 times
...
Refugia
7 months ago
I think the correct answer is A) The connection environment SQL executes when a session connects to the database.
upvoted 0 times
...

Save Cancel