Interested to Buy Any Domain ? << Click Here >> for more details...
Source Like
department_no, employee_name
----------------------------
20, R
10, A
10, D
20, P
10, B
10, C
20, Q
20, S
and Output should be like this
department_no, employee_list
--------------------------------
10, A
10, A,B
10, A,B,C
10, A,B,C,D
20, A,B,C,D,P
20, A,B,C,D,P,Q
20, A,B,C,D,P,Q,R
20, A,B,C,D,P,Q,R,S
- 3 Answers
- 10000 Views
- I also Faced
- E-Mail Answers
Answer Posted / subhash
small modification to the above ans:
SRC---->Transformer--->TGT
we do the 'HASH' partitioning on Dept_No.
SetNull value to the Stage variable----->SV_List
In the transformer stage variables:
SV_List :',' : Employee_Name ----->SV_List (Concatenating Employee
Names)
In the Column Derivation:
TRIM(SV_list, ',' , 'L')------->Employee_Name
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
what is use of SDR function?
What is a ds designer?
What are the different common services in datastage?
What is the sortmerge collector?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are sequencers?
What is difference between symmetric multiprocessing and massive parallel processing?
Notification Activity
What are the main features of datastage?
What is aggtorec restructure operator?
What are the some differences between 7.x and 8.x version of datastage?
What is the project in datastage?
Explain connectivity between datastage with datasources?
What are stage variables and constants?
How to reverse the string using SQL?
