Referring to the SQL Transformation: Which Statements Is Correct and True

question 25

Multiple Choice

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

• 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
• C) In PowerCenter 9 the SQL transformation, in query mode, can only be active
• 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 (!)

---

Definitions:

Problem Solving

A cognitive process involving the identification and resolution of an issue or obstacle.

Health Assessment

A systematic method for evaluating the health status of an individual, incorporating physical examination, history taking, and diagnostic testing.

Genomics

The branch of molecular biology concerned with the structure, function, evolution, and mapping of genomes.

Genogram

A graphic representation of a family tree that displays detailed data on relationships among individuals, often used to identify patterns of mental and physical illnesses.