hi how to do duplicate one target and distinct values one ta

[harikumar]

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

[anbu]

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

[anbu]

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

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

[ray.wurlod]

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