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
13431 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 are the different type of jobs in datastage?

1002

What are the functionalities of link partitioner?

972

What are the components of datastage?

1063

Can you explain players in datastage?

1142

What are system variables and sequencers in datastage

1067

What are the components of ascential data stage?

1110

What is the sortmerge collector?

1080

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1504

Differentiate between datastage and datastage tx?

1003

Name the different types of Lookups in Datastage?

1214

How to manage date conversion in Datastage?

1069

What are constraints and derivations?

1112

What are some prerequisites for datastage?

1041

Define orabulk and bcp stages?

1067

What are the different types of lookups in datastage?

1006