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
- 9941 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
sed,awk,head
what are the errors,warnings in datastage
What is the flow of loading data into fact & dimensional tables?
Where do the datastage jobs get stored?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Name the different types of Lookups in Datastage?
What all the types of jobs you developed?
What is the command line function to import and export the ds jobs?
What is the difference between datastage and informatica?
In Datastage, how you can fix the truncated data error?
what are the devoleper roles in real time? plz tell i am new to datastage....
Can you explain repository tables in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is the purpose of pivot stage and types of containers in datastage
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
