SRC---->Transformer--->TGT we do the 'HASH' partitioning.

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

Question Posted / subhash

3 Answers
10135 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

Please Help Members By Posting Answers For Below Questions

How complex jobs are implemented in datstage to improve performance?

1096

What are the various kinds of containers available in datastage?

1101

Define project in datastage?

1149

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1064

what is 'reconsideration error' and how can i respond to this error and how to debug this

2675

Nls stands for what in datastage?

1238

Can you explain link buffering?

1223

How to convert RGB Value to Hexadecimal values in datastage?

4060

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

981

What are the enhancements made in datastage 7.5 compare with 7.0?

1210

What are the different type of jobs in datastage?

1083

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1467

CHANGE CAPTURE

1354

Differentiate between odbc and drs stage?

1104

What are the differences between datastage and informatica?

1229