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
13672 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 job control?

1097

what is flow of project?

1979

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2235

describe the Steps to confiure a Qlogic switch

2369

Differentiate between hash file and sequential file?

1051

What are the different layers in the information server architecture?

1116

root tree will find which is server job and which is parallel job?

1944

What are the difference types of stages?

1185

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2208

What are the different kinds of views available in a datastage director?

1017

How many types of sorting methods are available in datastage?

1057

how many rows sorted in sort stage by default in server jobs

3984

Can you implement SCD2 using join, transformer and funnel stage?

1533

how to write server Routine coding?

2099

What is the difference between account and directory options ?

1163