Home » Developer & Programmer » Data Integration » Joiner with more than two tables
icon5.gif  Joiner with more than two tables [message #211162] Tue, 26 December 2006 22:56 Go to next message
soumyajit_biswas
Messages: 1
Registered: December 2006
Location: Kolkata
Junior Member
Is there any way to use a single joiner component in OWB which will be used to join more than 2 tables?
I am new to OWB....so plzzzz help me.
Re: Joiner with more than two tables [message #211301 is a reply to message #211162] Wed, 27 December 2006 20:20 Go to previous messageGo to next message
kkvna1
Messages: 1
Registered: December 2006
Location: Chennai
Junior Member
Hi,

you can add Input Group in the joiner. Basically in joiner you will be having 2 input groups and 1 output group. If you want to join more table you have to add the input group.

select the joiner
right clik it
select edit
go to groups tab
select the input group
clik add

once the input group is created you can join tables

this may help you

bye.
Re: Joiner with more than two tables [message #356099 is a reply to message #211162] Wed, 29 October 2008 09:00 Go to previous message
nithinlenin
Messages: 9
Registered: October 2008
Location: Bangalore
Junior Member
Is there any transformation where in i cn use two input groups and two output groups .
ie same functionality as the joiner , but i need to capture tose records too which doesn't fulfill the join condition
Previous Topic: extract data from flat file into target table
Next Topic: SQL LOADER - filenames
Goto Forum:
  


Current Time: Tue Aug 22 08:15:33 CDT 2017

Total time taken to generate the page: 0.01510 seconds