Multiple choice technology databases

A multifield transformation does which of the following?

  1. Converts data from one field into multiple fields

  2. Converts data from multiple fields into one field

  3. Converts data from multiple fields into multiple fields

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A multifield transformation (like Normalizer) can perform all three patterns: splitting one field into many (parsing), combining multiple fields into one (concatenation/aggregation), and mapping multiple fields to multiple fields (complex restructuring). Informatica's Normalizer is the classic multifield transformation.

Keep practicing — related questions