This discussion is archived
3 Replies Latest reply: Feb 15, 2013 12:19 PM by rp0428 RSS

Need a logic to load a table

991357 Newbie
Currently Being Moderated
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.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points