1.How do u handle NULL in sequential stage.
2.Difference between switch stage and filter stage.
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 |
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 all the types of jobs you developed?
ename like ibm,tcs,hcl need display those records only how?
what is advantages of snowflake when it is used?
How to implement complex jobs in data stage?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
How a routine is called in datastage job?
What is the process of killing a job in datastage?
What is the difference between datastage and informatica?
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
what is main difference between change capture and change apply stages
in oracle target stage when we use load option and when we use upsert option?