3 Replies Latest reply: Feb 15, 2013 2:19 PM by rp0428 RSS

    Need a logic to load a table

    991357
      Hi All,

      I am trying to figure out a logic to load a table from 3 differnt tables... below are the tables
      Contact                                                  
      --------------                           
      contact_id        DS_ID                           
      (Number)       (Varchar2)                     
      
      
      CR_TYpe 
      ---------- 
      CR_Type_ID          CR_Type  
      (Number)            (Varchar2)
      
      
      Source_CR_Type
      --------------  
      S_CR_Type_ID          CR_TYPE
      (Varchar2)             (Varchar2)
      Contact.DS_ID =Source_CR_Type.S_CR_Type_ID (the relation between contact and Source_CR_Type is 1:M)

      Distinct Source_CR_Type.CR_TYPE = CR_TYpe.CR_Type


      The table that needs to be loaded is MAP_CON_CR_TYPE
      MAP_CON_CR_TYPE
      -----------------------------
      MAP_ID          COntact_id          CR_Type_ID              
      (Number)        (Number)            (Number)
      sequence
      can any one help me with a logic to load this bridge table or suggest me how to approch.

      Edited by: BluShadow on 15-Feb-2013 15:26
      added {noformat}
      {noformat} tags for readability.  Please see {message:id=9360002} to learn to do this yourself in future.