switch and filter

pavan_test · Post by **pavan_test** » Thu Mar 23, 2006 2:16 pm

Hi All.,

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

thanks
pavi

vcannadevula · Post by **vcannadevula** » Thu Mar 23, 2006 2:21 pm

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 .

pavan_test · Post by **pavan_test** » Thu Mar 23, 2006 2:25 pm

Thanks
pavi

ray.wurlod · Post by **ray.wurlod** » Thu Mar 23, 2006 6:58 pm

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

DSXchange