venkat

• Jul 17th, 2006

 

You can use the joiner transformation by setting as outer join of either master or detail.

Motilal

 Profile Answers by Motilal 

• Jul 17th, 2006

 

Hi,

Look-up transformation can serve in so many situations.

So, if you can a bit particular about the scenarioo that you are talking about, it will be easy to interpret.

srisailu

 Profile Answers by srisailu 

• Jul 31st, 2006

 

Hi,

  lookup's either we can use first or last value. for suppose lookup have more than one record matching, we need all matching records, in that situation we can use master or detail outer join instead of lookup.(according to logic)

muzamil

• Aug 2nd, 2006

 

 You can use joiner in place of lookup

Prasad P

• Jun 10th, 2007

 

You can join that table which you wanted to use in lookup in the source qualifier using SQL override to avoid using lookup transformation