7 Replies Latest reply: Apr 21, 2010 9:38 AM by AnkitModi RSS

    Want to Solve the Query using Mapping Load

    AnkitModi

      Hi,

      Please help my query using Mapping Load instead of using JOIN, as i am not much aware of mapping load

      I have 2 table

      Table1:

       

      IR_DPDno of Accts
      0 - 29 DPD24,443
      30 - 59 DPD11,770
      60 - 89 DPD8,426
      90 - 119 DPD8,001
      120 - 149 DPD1
      180 - 209 DPD1
      240 - 269 DPD1
      390 - 419 DPD2
      Current317,066
      GWO3,938
      NCL68,928


      Table 2:

       

      IR_DPDFullPOSPOS
      0 - 29 DPD631,626,1081
      30 - 59 DPD303,230,5182
      60 - 89 DPD215,404,7293
      90 - 119 DPD203,847,2304
      120 - 149 DPD320,9465
      180 - 209 DPD376,8626
      240 - 269 DPD914,5507
      390 - 419 DPD497,4578
      Current12,394,438,4309


      Now i want the Table 2 data should join into Table1(using mapping load). and the output i should get is:

       

      IR_DPDno of AcctsFullPOSPOS
      0 - 29 DPD24,443631,626,1081
      30 - 59 DPD11,770303,230,5182
      60 - 89 DPD8,426215,404,7293
      90 - 119 DPD8,001203,847,2304
      120 - 149 DPD1320,9465
      180 - 209 DPD1376,8626
      240 - 269 DPD1914,5507
      390 - 419 DPD2497,4578
      Current317,06612,394,438,4309
      GWO3,938--
      NCL68,928--


      Thanks