Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 8248 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / himanshu jain
you can achieve this with AGGREGATOR and PIVOT ENTERPRISE stage in DATASTAGE Designer. First get count by using AGGREGATOR stage and then do Pivoting.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the main features of datastage?
what is ds administrator used for?
What is the command line function to import and export the ds jobs?
How do you remove duplicate values in datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
what are the devoleper roles in real time? plz tell i am new to datastage....
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How you can fix the truncated data error in datastage?
What is meta stage?
What are the components of ascential data stage?
Lookup constraints
What are the various kinds of the hash file?
What is active and passive stage?
what is the difference between == and eq in UNIX shell scripting?
Notification Activity
