DSXchange

hi
i have table(source) like

empno ename
10 a
20 b
10 c
30 d
20 g
30 h

i want to do output like

target1

empno ename
10 a
20 b
30 d


target2

empno ename
10 c
20 g
30 h

Do you have any rules to tell particular ename to be in target1 or in target2?

You can use sort stage and set Create Change Key Column to true.

Use constraint KeyChange=1 for table1 and KeyChange=0 for table2

This precise question has been asked previously, and by you, and an answer was provided.