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

Informatica PR000041 Exam - Topic 2 Question 17 Discussion

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

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

Suggested Answer: C

Get Premium PR000041 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
12 comments · newest first
DE
Deandrea 1 year ago
Yeah, I've seen the exclamation marks used for binding parameters.
CR
Cristy 1 year ago
Wait, are you sure about D? I thought it was different!
CO
Corrinne 1 year ago
C is correct, query mode is only active in PowerCenter 9.
MI
Mirta 1 year ago
I think B is misleading, it can't vary that much.
DE
Denny 1 year ago
A is definitely true, it can handle multiple records.
ST
Stefan 1 year 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.
MA
Marta 1 year ago
I remember practicing with query mode, and I feel like option B is correct since it mentioned varying components in SQL statements.
TA
Tamala 1 year ago
I think option A sounds familiar, but I'm not entirely sure if the SQL transformation can handle multiple records in script mode.
TR
Trinidad 1 year ago
Option C seems a bit off to me; I thought the SQL transformation could be both active and passive in PowerCenter 9.
LO
Lovetta 1 year ago
I'm a bit confused here. Is the $val variable being passed by reference or by value? That could affect the output.
MA
Marjory 1 year 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.
SH
Shizue 1 year 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.
0/2000 characters

Save Cancel