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
Can you explain repository tables in datastage?
What are the types of containers?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Define ds designer?
What are routines in datastage?
How can we improve the performance in datastage?
Enlist various types of routines in datastage.
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How you Implemented SCD Type 1 & Type 2 in your project?
describe the Steps to confiure a Qlogic switch
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
Differentiate between data file and descriptor file?
CHANGE CAPTURE
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys