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
- 9842 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
What is quality stage?
On which interface you will be working as a developer?
sed,awk,head
What is the difference between passive stage and active stage?
Can you explain tagbatch restructure operator?
Difference between sequential file and data set?
What are datastage sequences?
what is the use of skid in reporting?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Why do we use exception activity in Datastage?
What is the purpose of pivot stage and types of containers in datastage
Explain the situation where you have applied SCD in your project?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Name the different types of Lookups in Datastage?
What is orabulk stage?
