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

For flat file sources in a mapping, the Source Qualifier transformation must immediately follow the source definition. The Source Qualifier represents the rows that the Integration Service reads from the flat file and is required for all source types including flat files.