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
- 9845 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas
By using the stage variables in transformer we can do this.
Before going to use transformer sort the data based on two columns.Order should be like below
Deptno Empname
10 A
10 B
SO ON...
After that in transformer take 3 stage varibles
stg1--->map the sorted Deptcolumn
stg2---> DSLink2.empname:',' (map the empname column and concatenate comma operator)
Stg2--->stg3:stg2 (concatenate first two staging varibles)
Then
In derivation of employee_list column (In transformer)
use below function
TRIM(stg3,',','T')---->employee_list (column derviarion)
It will gives you as expected result.
Thanks
Sri
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What are the functionalities of link collector?
How to read multiple files using a single datastage job if files have the same metadata?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Define orabulk and bcp stages?
What is the project in datastage?
What are stage variables?
What are routines in datastage? Enlist various types of routines.
Why fact table is in normal form?
Can we use target hash file as a lookup ?
What are the differences between datastage and informatica?
what is use of SDR function?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the different type of jobs in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
how to sort two columns in single job in datastage.
