Saturday, November 17, 2007

Filter transformation

A Filter transformation contains the following condition: ITEM_COST > 100.00. The value for ITEM_COST for a specific row is 35. What will happen to that row?

Choose Answer

(A)
It is dropped from the mapping flow.
(B)
It is dropped from the mapping flow and written to the appropriate reject (bad) file.
(C)
It is dropped from the mapping flow and written to the appropriate reject (bad) file if the Filter property "Forward Filtered Rows" is set to True.
(D)
If the Filter property "Forward Filtered Rows" is set to True, the row is sent to downstream transformations, if any, but not written to the target table.