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
10 months ago
Yeah, I've seen the exclamation marks used for binding parameters.
upvoted 0 times
...
Cristy
11 months ago
Wait, are you sure about D? I thought it was different!
upvoted 0 times
...
Corrinne
11 months ago
C is correct, query mode is only active in PowerCenter 9.
upvoted 0 times
...
Mirta
11 months ago
I think B is misleading, it can't vary that much.
upvoted 0 times
...
Denny
11 months ago
A is definitely true, it can handle multiple records.
upvoted 0 times
...
Stefan
11 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
11 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
11 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
11 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
11 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
11 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
12 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