DSXchange

Hi All.,

can anyone please tell me the difference between filter and switch stages in datastage.

thanks
pavi

pavan_test wrote:Hi All.,

can anyone please tell me the difference between filter and switch stages in datastage.

thanks
pavi

Filter can be used as a where clause in the SQL. This is useful for the datasets or sequential files which donot have where clause option.


Switch is basically the case statement in C. specify the selector and the data condition for the selector .

Thanks
pavi

Switch is only on the value of the selector.
Filter is based on an expression (a WHERE-like expression, though LIKE requires regular expressions).