Switch stage

san_dwh · Post by **san_dwh** » Thu Dec 30, 2010 5:21 am

how switch stage differs from sql (may be in functionality)?

chulett · Post by **chulett** » Thu Dec 30, 2010 9:44 am

Fixed your subject three times now. Please use meaningful and appropriate subjects in the future.

Post by **daignault** » Thu Dec 30, 2010 10:40 am

You need to ask a question with more details.

The Switch Stage is a Datastage ETL stage used much like an SQL Where clause. SQL is a database language used to manipulate data.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 30, 2010 4:03 pm

The Switch stage is closest to the switch construct in the C programming languages. It is quite unlike anything in SQL. The closest SQL construct is CASE, but even CASE allows for expressions - switch does not, being driven purely by values.

The Filter stage uses SQL-like WHERE clauses.