wt is the difference between swith and filter stage

Answer Posted / kiran

Hai Swamy..,

How are You?

Your Ans is wrong boss.

In filter Stage we can give multiple conditions on
multiple columns,But every time data come from source
system and filtered data loads into target .where as in
switch stage we can give Multiple conditions on Single
column,but data come only once from the source and checks
all the conditions in the switch stage and loads in to
target.

Please correct ur ans.
Thank u

Is This Answer Correct ?    27 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you generate sequence number in datastage?

629


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

532


What can we do with datastage director?

679


What is the difference between Datastage 7.5 and 7.0?

679


How do you reject records in a transformer?

635






how to sort two columns in single job in datastage.

2549


How do you run datastage job from the command line?

607


On which Dimension Table you implemented SCD Type in your Project

1588


What is usage analysis in datastage?

827


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

545


What are constraints and derivations?

662


how can we create rank using datastage?what is the meaning of rank?

8196


Define Job control?

683


What are the partitioning techniques available in link partitioner?

1761


What are the steps needed to create a simple basic datastage job?

667