select eno, ename, count(*) from Table

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

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

Answer Posted / ajajsp

select eno, ename, count(*) from Table_Name group by eno, ename

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Highlight the main features of datastage?

1148

Difference between sequential file and data set?

1190

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1376

In Datastage, how you can fix the truncated data error?

1148

What is the difference between in process and inter process?

1130

What are constraints and derivations?

1155

What are the types of containers?

1214

What are data elements?

1159

Distinguish between informatica & datastage. Which one would you choose and why?

996

Describe stream connector?

1298

What is aggtorec restructure operator?

1427

Can you explain kafka connector?

1291

How can you write parallel routines in datastage PX?

1003

CHANGE CAPTURE

1294

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3106