Multiple choice technology

A transformation has the following ports: Port_1: String, input port; Port_2: String, input port; Port_3: String, output port. TECHWEEK is a string literal. Which of the expressions shown below would be valid for Port_3?

  1. Port_1 || Port_2 || 'TECHWEEK'

  2. Port_1 || Port_2 || "TECHWEEK"

  3. Port_1 || Port_2 || TECHWEEK

  4. CONCAT(Port_1, ‘CONCAT(Port_2, "TECHWEEK")’)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In PowerCenter transformation expressions, string literals must be enclosed in single quotes. Double quotes are used for identifiers, and unquoted text would be interpreted as a column name. The || operator correctly concatenates the ports and the string literal in option A.

Keep practicing — related questions