Informatica scenario

department_no, employee_name
20, R
10, A
10, D
20, P
10, B
10, C
20, Q
20, S
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