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
How do you generate sequence number in datastage?
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)
What can we do with datastage director?
What is the difference between Datastage 7.5 and 7.0?
How do you reject records in a transformer?
how to sort two columns in single job in datastage.
How do you run datastage job from the command line?
On which Dimension Table you implemented SCD Type in your Project
What is usage analysis in datastage?
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
What are constraints and derivations?
how can we create rank using datastage?what is the meaning of rank?
Define Job control?
What are the partitioning techniques available in link partitioner?
What are the steps needed to create a simple basic datastage job?