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
- 9372 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
Can you explain how could anyone drop the index before loading the data in target in datastage?
Define Data Stage?
Highlight the main features of datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are routines in datastage?
How can one find bugs in job sequence?
What is the difference between operational data stage (ods) and data warehouse?
What are the various kinds of the hash file?
Why do you need stage variables?
How will you move hashed file from one location to another location?
How can you write parallel routines in datastage PX?
In Datastage, how you can fix the truncated data error?
How to Remove Duplicate using SQL?
How many types of hash files are there?
