Senario 2

1. Separating duplicate and non-duplicate rows to separate tables.
   Solution: This can be achivied through this way :
   

   

   

   

    
   

   After SQ use Aggregator Transformation and add a port o_COUNT of variable type with value

   as COUNT(ID), Select group by all ports. 

   Take a Router Transformation drag all ports from Aggregator and create two groups with following conditions:

   Unique = o_COUNT=1

   Duplicate=o_COUNT>1

   Connect the respective groups to their targets.

   
   

   Video :