Informatica : Lookup Instead Of Joiner to Join Source Files

How do you join 2 source files without using Joiner Tranformation. So to do that, we will use Lookup on Flat File.

[rakeshbidhar]

Very good collection of videos Mandar.

[mrgogate]

Note - Using lookup will not work same as Joiner in all cases. e.g. If you have data in which Dep table has 2 or more entires for a particular employee then
, Joiner will give you 2 results as a output whereas Lookup will return only one row based on what property you will select.