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.
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 is the use of skid in reporting?
how to write server Routine coding?
How will you move hashed file from one location to another location?
How a source file is populated?
How do you generate sequence number in datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is oci?
What are stage variables?
Differentiate between Join, Merge and Lookup stage?
What is the method of removing duplicates, without the remove duplicate stage?
how can we create rank using datastage?what is the meaning of rank?
Define APT_CONFIG in Datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
How rejected rows are managed in datastage?
which r the connectors used in san?