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
- 8439 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / purba
For Datastage:
I/p........sort stage(create key change column for empno.)........ transformer ( here take stage variables count=0,sv1. For sv1 give derivation as(if keychange=1 then sv1=ename else sv1=sv1:',':ename) for count derivation (if keychange=1then count=1 else count=count +1).........remove duplicate stage(retain last)......o/p(desired result)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Have you used Unstructured data?
How we can covert server job to a parallel job?
Can you define merge?
Why do you need stage variables?
client know skid info?
What is difference between server jobs & parallel jobs?
If you want to use the same piece of code in different jobs, how will you achieve it?
How to implement complex jobs in data stage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are the primary usages of datastage tool?
What are stage variables, derivations and constants?
What is the difference between an operational datastage and a data warehouse?
What is the sortmerge collector?
In Datastage, how you can fix the truncated data error?
Describe stream connector?
