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
- 8438 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / msbharathi
Seq stg------>Sort stg--------> Trnsfrm stg-------->Tgt
1. read data in seq file stage.
2. In sort stage enable key column change as true.
3. In transformer stage define stage variable SV1 (if DSLink5.keyChange = 1 then 1 else SV1 +1) and SV2 (if DSLink5.keyChange = 1 then DSLink5.ENAME else SV2 : ',' : DSLink5.ENAME
) . In output tab link ENO, SV2 -> Ename and SV1 -> Count. Add a constraint LastRowInGroup(DSLink5.ENO) and mark the ENO as key in input column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert RGB Value to Hexadecimal values in datastage?
What are the functionalities of link partitioner and link collector?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
root tree will find which is server job and which is parallel job?
How many types of stage?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Define data aggregation?
What is datastage engine?
sed,awk,head
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the some differences between 7.x and 8.x version of datastage?
EXPLAIN SCD
What is the difference between server job and parallel jobs?
What are the enhancements made in datastage 7.5 compare with 7.0?
