Informatica PR000041 Exam - Topic 2 Question 17 Discussion

Actual exam question for Informatica's PR000041 exam

Question #: 17
Topic #: 2

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

AThe SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline

BThe SQL transformation in query mode can execute multiple SQL statements where components of the SQL Statement can vary from one execution to the next

CIn PowerCenter 9 the SQL transformation, in query mode, can only be active

DWhen 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 (!)

Show Suggested 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:

Submit Cancel

Deandrea

7 months ago

Yeah, I've seen the exclamation marks used for binding parameters.

upvoted 0 times

...

Cristy

7 months ago

Wait, are you sure about D? I thought it was different!

upvoted 0 times

...

Corrinne

7 months ago

C is correct, query mode is only active in PowerCenter 9.

upvoted 0 times

...

Mirta

7 months ago

I think B is misleading, it can't vary that much.

upvoted 0 times

...

Denny

8 months ago

A is definitely true, it can handle multiple records.

upvoted 0 times

...

Stefan

8 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

8 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

8 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

8 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

8 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

8 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

8 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

...