1.How do u handle NULL in sequential stage.
2.Difference between switch stage and filter stage.
- 4 Answers
- 9819 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashok
2.in switch stage we can write conditions on only one field
(column).but in filter we can write conditions on multiple
fields.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / xxx
in sequvential file,click on columns tab and click on left
side of column then we can provide null field value.
diff between switch and filter is ,switch is expression
based and filter is condition based
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sruthi
The main difference between switch and filter is switch supports only 128 output links where as filter stage can have any any number of output links
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / venkataramireddy
Switch:we can write the mutiple conditions on single
column , it suport one input and 128 outputs.
Filter: We can write multiple conditions on mutiple
columns, it supports one input and n outputs.
| Is This Answer Correct ? | 1 Yes | 1 No |
root tree will find which is server job and which is parallel job?
What are the enhancements made in datastage 7.5 compare with 7.0?
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.
What is the function in Transformer stage can act as Rank Function in oracle
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
how many dimentions and fact tables used in your project and what are names of it?
How do you reject records in a transformer?
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
What is the difference between datastage and datastage tx?
What is the difference between datastage and informatica?
Teradata 
