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
- 8129 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
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is a merge?
What is the sortmerge collector?
What are the steps needed to create a simple basic datastage job?
Describe routines in datastage? Enlist various types of routines.
What are the various kinds of containers available in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Differentiate between odbc and drs stage?
How can we improve the performance in datastage?
What is difference between join, merge and lookup stage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is ibm datastage?
How do y read Sequential file from job control?
