Which transformation is used for restricting rows based on condition
-
Conditional
-
Filter
-
Router
-
Source Qualifier
B
Correct answer
Explanation
The Filter transformation restricts rows in a data flow by evaluating a specified condition; only rows that satisfy the condition are passed through. Distractors like Router split rows into multiple groups, Source Qualifier defines source properties, and Conditional is not a standard transformation name.