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
Joining using Transformer Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 194
- Joined: Thu May 11, 2006 9:42 am
Joining using Transformer Stage
Thanks,
Chris Jones
Chris Jones
-
- Participant
- Posts: 194
- Joined: Thu May 11, 2006 9:42 am
Joining using Transformer Stage
Thanks for the info..
But here ODBCstage is left or Oraclestage Left?
But here ODBCstage is left or Oraclestage Left?
Thanks,
Chris Jones
Chris Jones
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.
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.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact: