DSXchange

Hi,
I would like to know how to configure oraoci9 stage in server 7.5 for a outer join between two tables.
Table A
---------
last name
first name
ssn

Table B
----------
ssn
suffix
middle initial

I would like to join on ssn.
Thanx in advance.

You dont need to configure anything. Just deal with the sql.

• -Load the meta data of both the tables
  -In the derivations, prefix it with the table alias name that you are going to use. Say A for Table A and B for Table B
  -When you go to sql tab, the generated sql will show

  Code: Select all

  select A.last_name, A.first_name, A.ssn, B.suffix, B.middile_initial from Table_A A
  

  -In the others section you will put

  Code: Select all

  left outer join Table_B B ON
  A.ssn = B.ssn
  

Thats about it. Similarly you can do a different joins.

sdfasih wrote:Hi,
I would like to know how to configure oraoci9 stage in server 7.5 for a outer join between two tables.
Table A
---------
last name
first name
ssn

Table B
----------
ssn
suffix
middle initial

I would like to join on ssn.
Thanx in advance.

You dont need to configure anything in the OCI stage to do an outer join.
All you need to write a query to do it.
check this linkto know about the various joins in Oracle.

You can also use the SQL Builder or Fully Generated option in the OCI stage. If outer joins are mysterious to you, it will walk you through the process.