OraFAQ Forum: Data Integration » DIFFERENCE BETWEEN LOOKUP AND JOINER

Home » Developer & Programmer » Data Integration » DIFFERENCE BETWEEN LOOKUP AND JOINER (

) 1 Vote

Fri, 09 February 2007 00:08

arnie_nits
Messages: 1
Registered: January 2007

Junior Member

i'm a beginner...
can someone explain me the DIFFERENCE BETWEEN LOOKUP AND JOINER

Thanks
Arnie

Sun, 25 March 2007 03:06

kiran
Messages: 503
Registered: July 2000

Senior Member

Lookup - Looks up for a value in a group of values.
Joiner - Joins records from different databases or flat files.

-Kiran.

Mon, 07 July 2008 09:31

Rc56452
Messages: 3
Registered: July 2008

Junior Member

look-up performs right outer join with the look up table if given no- match rows returns NULL

-joiner performs equi join

Wed, 29 October 2008 08:45

nithinlenin
Messages: 9
Registered: October 2008
Location: Bangalore

Junior Member

is it possible to capture both match and no-match rows using lookup

Previous Topic:	Help required
Next Topic:	Problem in Import of Tables from SQL Server

Goto Forum:

]

Current Time: Thu Mar 23 23:16:17 CDT 2023