For Datastage: I/p........sort stage(create key change column for empno.).

eno ename
1 qaz
1 wsx
1 edc
2 zxc
2 asd
3 qwe
3 wer
3 tru
4 rgj

Output:

eno ename count
1 qaz,wsx,edc 3
2 zxc,asd 2
3 qwe,wer,tru 3
4 rgj 1

I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

Question Posted / purba

4 Answers
8293 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / purba

For Datastage:
I/p........sort stage(create key change column for empno.)........ transformer ( here take stage variables count=0,sv1. For sv1 give derivation as(if keychange=1 then sv1=ename else sv1=sv1:',':ename) for count derivation (if keychange=1then count=1 else count=count +1).........remove duplicate stage(retain last)......o/p(desired result)

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Difference between in process and inter process?

1240

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

1293

What is the process of killing a job in datastage?

1020

How will you move hashed file from one location to another location?

2152

What are stage variables?

1204

How the ipc stage work?

1130

What is the purpose of interprocessor stage in server jobs?

2233

How to Remove Duplicate using SQL?

1371

Notification Activity

1408

what is ds administrator used for?

1173

Differentiate between odbc and drs stage?

1050

Why do we use exception activity in Datastage?

1315

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3795

How to manage date conversion in Datastage?

1138

How a routine is called in datastage job?

1111