Which of the following techniques could be used to filter data read from a flat file source?
A. Create a valid condition in the Filter attribute of the flat file’s Source Qualifier
B. Place a Filter transformation directly after the flat file’s Source Qualifier
C. An Expression transformation with an output port’s expression defined to filter records
D. An Expression transformation with all of the output port’s default values set to blank
a also is right
You can´t filter data from flat file inside of source qualifier (the option to filter data is inactive for flat file), so you should add a filter transformation after the source qualifier.
Option B is correct.