Joining using Transformer Stage

chrisjones · Post by **chrisjones** » Thu Aug 12, 2010 2:21 pm

Hi ,
I noticed one server job design with as below.

ODBCStage--->HashFile
|

|
Oraclestage------>Transformer---->SeqFile

Based on SID Key they are joining Hashfile and Transformer but i want to know exactly which join they are doing..i mean innier or ourter or left?Please help me how to find this

anbu · Post by **anbu** » Thu Aug 12, 2010 2:35 pm

Left outer join

chrisjones · Post by **chrisjones** » Thu Aug 12, 2010 2:41 pm

Thanks for the info..

But here ODBCstage is left or Oraclestage Left?

anbu · Post by **anbu** » Thu Aug 12, 2010 2:53 pm

Left on the stream link

kumar_s · Post by **kumar_s** » Thu Aug 12, 2010 2:59 pm

All the data from the Oracle will pass through the Transformer and do a lookup against ODBC and find the corresponding match based on the key.
If no extra constraint been given in the Transformer, all the records from the input record (Oracle) will flow to the output.

Now you can decide, which outer is this.

vivekgadwal · Post by **vivekgadwal** » Fri Aug 13, 2010 8:09 am

As kumar_s pointed out, it depends on the condition in the Transformer. Please check the constraint and see if any condition like <Column from Hashed file>.NOTFOUND is mentioned.

arunkumarmm · Post by **arunkumarmm** » Fri Aug 13, 2010 1:07 pm

If you do not have any constrain, It will be left.

If you want a inner join use Not(<LookupLinkName>.NOTFOUND) in the constrain.