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
- 9838 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
What steps should be taken to improve Datastage jobs?
Nls stands for what in datastage?
What are the different options associated with dsjob command?
How we can covert server job to a parallel job?
Explain the situation where you have applied SCD in your project?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the types of jobs we have in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Is it possible to query a hash file?
Explain the importance of surrogate key in data warehousing?
What is staging variable?
What are transforms and what is the differenece between routines and transforms?
Differentiate between datastage and datastage tx?
Difference between server jobs & parallel jobs?
What is meta stage?
