nikhilboorla Posted March 17, 2015 Report Posted March 17, 2015 src: prod_id src_type Amt 101 1 300 102 1 100 103 2 150 105 2 450 101 1 300 106 2 140 tgt1: prod_id src_type amt 101 1 300 102 1 100 tgt2: prod_id src_type amt 103 2 150 105 2 450 106 2 140 how to divide into 2 tgts with above o/p?? which transformation to use??
kedharinath Posted March 17, 2015 Report Posted March 17, 2015 Dhantla antha difficulty eda kanpinchindh nek.
ronitreddy Posted March 17, 2015 Report Posted March 17, 2015 Use Sorter with distinct enabled Specify the rules for loading data into target
Mutton Kottu Masthan Posted March 17, 2015 Report Posted March 17, 2015 src: prod_id src_type Amt 101 1 300 102 1 100 103 2 150 105 2 450 101 1 300 106 2 140 tgt1: prod_id src_type amt 101 1 300 102 1 100 tgt2: prod_id src_type amt 103 1 ??? 2 150 105 1 ??? 2 450 106 2 140 how to divide into 2 tgts with above o/p?? which transformation to use?? Bro - Source - Sorter Distinct - Router Tx 2 Groups - Target 1 - Target 2 Router : 1st group: (PROD_ID = 101) OR (PROD_ID = 102) -------> Target 1 2nd group: (PROD_ID = 103) OR (PROD_ID = 105) OR (PROD_ID = 106) -------> Target 2
ATRI Posted March 17, 2015 Report Posted March 17, 2015 tgt1: prod_id src_type amt 101 1 300 102 1 100 tgt2: prod_id src_type amt 103 2 150 105 2 450 106 2 140 ila kavali ante Source Qualifier lo distinct select cheyi to remove dupliacate record and router transforamtion use chesi src_type =1 first grp sec-type=2 second grp and connect those 2 different tgts c
kedharinath Posted March 17, 2015 Report Posted March 17, 2015 Bro - Source - Sorter Distinct - Router Tx 2 Groups - Target 1 - Target 2 Router : 1st group: (PROD_ID = 101) OR (PROD_ID = 102) -------> Target 1 2nd group: (PROD_ID = 103) OR (PROD_ID = 105) OR (PROD_ID = 106) -------> Target 2sq lo distinct check sesthe saal..sorter avsram le..
Silent_Boy Posted March 17, 2015 Report Posted March 17, 2015 sq lo distinct check sesthe saal..sorter avsram le.. if source is flat file then??
kedharinath Posted March 17, 2015 Report Posted March 17, 2015 if source is flat file then?? then sorter..and distinct..
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts