Hi first sort the input date then use the transformer stage by using st

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 / vijaya

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

Answer Posted / vijaya

Hi

first sort the input date then use the transformer stage by
using stage variables you can use the logic like check the
first record then check the second record if both are equal
send the output to o/p1 or else send to o/p2....

I hope i made u understand the logic

Is This Answer Correct ?

2 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can you write parallel routines in datastage PX?

1065

Difference between sequential file and data set?

1261

CHANGE CAPTURE

1353

Define oconv () and iconv () functions in datastage?

1468

What are the areas of application?

1197

What is the sortmerge collector?

1176

Define data aggregation?

1148

What are orabulk and bcp stages?

1165

how to sort two columns in single job in datastage.

2957

How many types of views are there in a datastage director?

1340

How you Implemented SCD Type 1 & Type 2 in your project?

4179

What is process model?

2025

What are the steps required to kill the job in Datastage?

1266

What is apt_config in datastage?

1194

How do you import and export data into datastage?

1296