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
- 9978 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 are the steps needed to create a simple basic datastage job?
In Datastage, how you can fix the truncated data error?
Name the different sorting methods in datastage.
Distinguish between informatica & datastage. Which one would you choose and why?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are constraints and derivations?
What are the functionalities of link partitioner?
I have a few records just I want to store data in to targets cycling way how?
How do you reject records in a transformer?
What are the partitioning techniques available in link partitioner?
How to Remove Duplicate using SQL?
Differentiate between validated and Compiled in the Datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
Give an idea of system variables.
How do you schedule or monitoring the job?
