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
- 9988 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
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is a datastage job?
Define data aggregation?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Can you implement SCD2 using join, transformer and funnel stage?
what is use of SDR function?
What is the purpose of pivot stage and types of containers in datastage
What are the types of containers and how to create them?
Is the value of staging variable stored temporarily or permanently?
Differentiate between hash file and sequential file?
Define ds designer?
what is the use of skid in reporting?
Notification Activity
Define Merge?
How to read multiple files using a single datastage job if files have the same metadata?
