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 PR000041 Exam - Topic 2 Question 17 Discussion

Referring to the SQL Transformation: which statements is correct and true.
C) In PowerCenter 9 the SQL transformation, in query mode, can only be active
A) The SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline
B) The SQL transformation in query mode can execute multiple SQL statements where components of the SQL Statement can vary from one execution to the next
D) When you bind a parameter to an input port, you identify the port by name in the query. The SQL Editor encloses the name in exclamation question marks (!)

Informatica PR000041 Exam - Topic 2 Question 17 Discussion

Actual exam question for Informatica's PR000041 exam
Question #: 17
Topic #: 2
[All PR000041 Questions]

Referring to the SQL Transformation: which statements is correct and true.

Show Suggested Answer Hide Answer
Suggested Answer: C

by Aliza at May 09, 2022, 05:53 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Deandrea
8 months ago
Yeah, I've seen the exclamation marks used for binding parameters.
upvoted 0 times
...
Cristy
9 months ago
Wait, are you sure about D? I thought it was different!
upvoted 0 times
...
Corrinne
9 months ago
C is correct, query mode is only active in PowerCenter 9.
upvoted 0 times
...
Mirta
9 months ago
I think B is misleading, it can't vary that much.
upvoted 0 times
...
Denny
9 months ago
A is definitely true, it can handle multiple records.
upvoted 0 times
...
Stefan
9 months ago
I vaguely recall something about binding parameters, but I'm not sure if the exclamation question marks are the right symbols for identifying input ports in option D.
upvoted 0 times
...
Marta
9 months ago
I remember practicing with query mode, and I feel like option B is correct since it mentioned varying components in SQL statements.
upvoted 0 times
...
Tamala
9 months ago
I think option A sounds familiar, but I'm not entirely sure if the SQL transformation can handle multiple records in script mode.
upvoted 0 times
...
Trinidad
9 months ago
Option C seems a bit off to me; I thought the SQL transformation could be both active and passive in PowerCenter 9.
upvoted 0 times
...
Lovetta
9 months ago
I'm a bit confused here. Is the $val variable being passed by reference or by value? That could affect the output.
upvoted 0 times
...
Marjory
9 months ago
Okay, let's see. I think I need to add up the total costs for each vendor and compare them to the $310,000 budget. That should help me determine which vendor or vendors meet the criteria.
upvoted 0 times
...
Shizue
10 months ago
I've got a good feeling about Change Sets and Data Loader. Those are the two I'll focus on for this exam question.
upvoted 0 times
...

Save Cancel