Looking Up Multiple Tables
Posted: Fri Feb 14, 2003 5:01 pm
Dear All,
I have a Table Which contains Reference to Other Tables.I need to populate a New Table Based on This main table and the Reference Tables.
Eg..
Main Table 1 Ref Table2 REf Table 3
COL1 COL1 COL1
COL2 COL2 COL2
COL3 COL3 COL3
COL4 COL4 COL4
COL5 COL5 COL5
REST OF COLUMNS
In The Above Strture Assume COL2(TABLE1) REFER TO COL1(TABLE2) AND COL3(TABLE1) IS REFER TO COL1(TABLE3). No I need to Populate a New Table with the following NEW TABLE(
TABLE1(ALL COLUMNS) + TABLE2(COL2,COL3) + TABLE3(COL2,COL3,COL4) .
HOW WILL DO THIS IN DATA STAGE.Please explain me the Steps how to do this.
Note: I used ODBC Stage to connect to Oracle.
Thanks & Regards,
K.S.Rajan.
I have a Table Which contains Reference to Other Tables.I need to populate a New Table Based on This main table and the Reference Tables.
Eg..
Main Table 1 Ref Table2 REf Table 3
COL1 COL1 COL1
COL2 COL2 COL2
COL3 COL3 COL3
COL4 COL4 COL4
COL5 COL5 COL5
REST OF COLUMNS
In The Above Strture Assume COL2(TABLE1) REFER TO COL1(TABLE2) AND COL3(TABLE1) IS REFER TO COL1(TABLE3). No I need to Populate a New Table with the following NEW TABLE(
TABLE1(ALL COLUMNS) + TABLE2(COL2,COL3) + TABLE3(COL2,COL3,COL4) .
HOW WILL DO THIS IN DATA STAGE.Please explain me the Steps how to do this.
Note: I used ODBC Stage to connect to Oracle.
Thanks & Regards,
K.S.Rajan.