Page 1 of 1
Joining using Transformer Stage
Posted: Thu Aug 12, 2010 2:21 pm
by chrisjones
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
Posted: Thu Aug 12, 2010 2:35 pm
by anbu
Left outer join
Joining using Transformer Stage
Posted: Thu Aug 12, 2010 2:41 pm
by chrisjones
Thanks for the info..
But here ODBCstage is left or Oraclestage Left?
Posted: Thu Aug 12, 2010 2:53 pm
by anbu
Left on the stream link
Posted: Thu Aug 12, 2010 2:59 pm
by kumar_s
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.
Posted: Fri Aug 13, 2010 8:09 am
by vivekgadwal
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.
Posted: Fri Aug 13, 2010 1:07 pm
by arunkumarmm
If you do not have any constrain, It will be left.
If you want a inner join use Not(<LookupLinkName>.NOTFOUND) in the constrain.