Can we use lookup instead of join? reason

  • Interview Candidate
  • 2
  • 3395

Showing Answers 1 - 2 of 2 Answers

srinivas vadlakonda

  • Oct 11th, 2006
 

yes we can use the lookup transformation instead of joiner but we can take the homogeous sources only. If u r taking joiner we can join the heterogeneous sources.

  Was this answer useful?  Yes

sn3508

  • Oct 26th, 2006
 

If  the relationship to other table is a one to one join or many to one join then we can use lookup to get the required fields.  In case the relationship is outer join, joining both the tables will give correct results as Lookup returns only one row if multiple rows satisfy the join condition.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions