outer join in oraoci9 stage

[sdfasih]

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.

[DSguru2B]

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.

[narasimha]

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.

[chulett]

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.