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
- 8297 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
Where the datastage stored his repository?
What are the partitioning techniques available in link partitioner?
Differentiate between operational datastage (ods) and data warehouse?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is a ds designer?
What is difference between symmetric multiprocessing and massive parallel processing?
How do you remove duplicate values in datastage?
How many types of views are there in a datastage director?
What is a merge?
What is a quality stage in datastage tool?
Define Merge?
Can we use target hash file as a lookup ?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What steps should be taken to improve Datastage jobs?
