DSXchange

Hi all,

Just wanted to know what is the difference between a filter stage and switch stage .
as far as i know both do the same job.

correct me if i'm wrong and could some one explain the same

Thanks in advance

Here is post with which gives you a few.

A few major differences:

• -Filter stage can have any number of output links where as Switch stage is limited to a max of 128 links.
  -Filter stage can optionally have a reject link. Switch stage requires a reject link.
  -A switch stage is like the C swtich function. It goes through all the cases and if no cases are met, it goes for the default value, which is specified by the reject link.

Thats just to name a few. More can be found by reading the manual.

THE major difference is that the Switch stage operates on values, while the Filter stage operates on WHERE expressions, to determine which rows are sent along each output link.

sshettar wrote:Hi all,

Just wanted to know what is the difference between a filter stage and switch stage .
as far as i know both do the same job.

correct me if i'm wrong and could some one explain the same

Thanks in advance

In Filter, a single Input record can pass thru one or many output links aslong as each link satisfies a certain criteria
In Switch, a single INput record can ONLY pass thru one of the many output links.

Vijayrc said whatever Ray said, just in different words. That is infact, one of the major differences.