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

Source Qualifier transformation must be the first transformation after the source definition when working with flat files in Informatica mappings. It represents the rows that the Integration Service reads from the source when it runs a session. Expression, Filter, and Target transformations come later in the data flow pipeline.