Multiple choice technology

Which of the following transformations should be next to source transformation for flat file in the mapping?

  1. Expression transformation

  2. Source qualifier

  3. Target transformation

  4. Filter transformation

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Source Qualifier transformation is always required immediately after the source definition in a mapping. It represents the rows that the Integration Service reads from the source and allows you to filter rows or modify data type information. Expression (A), Filter (D), and Target (C) transformations come later in the data flow.