wt is the difference between swith and filter stage

Answer Posted / swamy

Hi,

The main diff between filter and switch stages..
filter performs on sql queries and we can declare 'n' num
of out puts for 'n' num of where clause conditions.
But in swith stage perfoms on single column level rows
only.. and every time it checks source system befor going
to load the data into target, but filter not like that.

If you have any doubt in this.... give a cal to my num..

Swamy - 9985223203

Is This Answer Correct ?    0 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are some different alternative commands associated with "dsjob"?

667


Nls stands for what in datastage?

732


What are orabulk and bcp stages?

655


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

672


Triggers,VIEW,Procedures

805






What are the types of containers and how to create them?

562


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2713


What are the enhancements made in datastage 7.5 compare with 7.0?

716


Is possible to create skid in dim,fact tables?

2195


What all the types of jobs you developed?

673


How do you schedule or monitoring the job?

677


What is the difference between odbc and drs stage?

645


options available in sequence job to run,validate?

846


What are the partitioning techniques available in link partitioner?

1761


What is the difference between server job and parallel jobs?

678