Home » Developer & Programmer » Data Integration » DIFFERENCE BETWEEN LOOKUP AND JOINER  () 1 Vote
DIFFERENCE BETWEEN LOOKUP AND JOINER [message #218611] Fri, 09 February 2007 00:08 Go to next message
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
Re: DIFFERENCE BETWEEN LOOKUP AND JOINER [message #226567 is a reply to message #218611] Sun, 25 March 2007 03:06 Go to previous messageGo to next message
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.
Re: DIFFERENCE BETWEEN LOOKUP AND JOINER [message #332110 is a reply to message #226567] Mon, 07 July 2008 09:31 Go to previous messageGo to next message
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
Re: DIFFERENCE BETWEEN LOOKUP AND JOINER [message #356093 is a reply to message #332110] Wed, 29 October 2008 08:45 Go to previous message
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: Fri Mar 29 03:55:20 CDT 2024