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
13432 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 to reverse the string using unix?

3431

How do you start developing a datastage project?

1057

Which commands are used to import and export the datastage jobs?

1359

How to reverse the string using SQL?

1425

What is meta stage?

1131

Is the value of staging variable stored temporarily or permanently?

930

What is active and passive stage?

1360

What is a folder? Difference types of stages?

1102

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

971

What are the differences between datastage and informatica?

1111

What is the flow of loading data into fact & dimensional tables?

1012

Explain how a source file is populated?

1312

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1137

How to read multiple files using a single datastage job if files have the same metadata?

1176

What are the various kinds of containers available in datastage?

974