Interested to Buy Any Domain ? << Click Here >> for more details...
1.How do u handle NULL in sequential stage.
2.Difference between switch stage and filter stage.
- 4 Answers
- 11070 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 |
How many number of reject links merge stage can have?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
what is the unix script to run the job? Please mention commands which we use often?
Why we use surrogate key?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
what is the difference between == and eq in UNIX shell scripting?
What are orabulk and bcp stages?
what is a force compile
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
how to sort two columns in single job in datastage.
Teradata 
