first sort the data, then take two stage variable if (sv1=sv2) then ds.

i/p o/p1 o/p2
1 1 4
1 1 5
1 1 6
2 2
2 2
2 2
3
3
4
5
6
how to populates i/p rows into o/p1&o/p2 using datastage
stages?and also the same scenario using sql?

Question Posted / srinivas

8 Answers
13766 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / srinivas

first sort the data,
then
take two stage variable
if (sv1=sv2) then ds.link1 else ds.link2

Is This Answer Correct ?

1 Yes

13 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the precedence of stage variables,derivations, and constraints?

1086

What are the differences between datastage and informatica?

1177

what are the errors,warnings in datastage

2700

What is difference between symmetric multiprocessing and massive parallel processing?

1144

Which algorithm you used for your hashfile?

1183

What is process model?

1980

Where do the datastage jobs get stored?

1218

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

8795

AGGREGATOR default datatype

1461

What a datastage macro?

1061

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1039

What is ds designer?

1105

What are the types of containers in datastage?

1191

What are the functionalities of link collector?

1085

How to reverse the string using SQL?

1533