How to store Multiple values in ODI Variable

Create one procedure

1) First write one select statement in SOURCE TAB

ex :  select deptno as DNO from dept

2) go to TARGET TAB calll below query

ex:  delete from emp where deptno = :DNO