How can you join two tables without using joiner and sql override transformations?

  • Interview Candidate
  • 9
  • 4829

Showing Answers 1 - 9 of 9 Answers

hanug

  • May 7th, 2007
 

U can use the Lookup Transformation to perform the join. Here u may not get the same results as SQL OVERRIDE(data coming from same soure) or Joiner(same source or different sources) because it takes single record in case of multi match

If one of the table contains, single record, u dont need to use SQL OVERRIDE or Joiner to join records. Let it perform catesion product. This way u dont need to use both(sql override, joiner)

Hanu.

  Was this answer useful?  Yes

chandrarekha

  • Sep 24th, 2007
 

you can join two tables with in the same database by using lookup query override

  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