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
- 9997 Views
- I also Faced
- E-Mail Answers
Answer Posted / subhash
SRC---->Transformer--->TGT
we do the 'HASH' partitioning.
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:
SV_list------->Employee_Name
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to convert RGB Value to Hexadecimal values in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Where the datastage stored his repository?
What are the types of containers in datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
whom do you report?
Differentiate between odbc and drs stage?
Explain datastage architecture?
What are the some differences between 7.x and 8.x version of datastage?
What is the difference between server job and parallel jobs?
What is datastage?
Define Merge?
What is the purpose of pivot stage and types of containers in datastage
What are sequencers?
