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
13663 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 we create rank using datastage?what is the meaning of rank?

8758

What are the various kinds of containers available in datastage?

1017

What is ds designer?

1078

Name the command line functions to import and export the DS jobs?

1132

What is data partitioning?

1176

How a routine is called in datastage job?

1080

What is a merge in datastage?

1242

Enlist various types of routines in datastage.

1225

How to RD using transformer?

1406

What is the difference between validated and compiled in the datastage?

1261

How can we improve performance of data stage jobs?

999

Define APT_CONFIG in Datastage?

1054

What are the job parameters?

1199

What is the use of datastage designer?

1134

What is a folder? Difference types of stages?

1152