Answer Detail: RE: How can you join two tables without using joiner a...

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

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

May 05, 2007 22:48:49	#1
hanug	Member Since: June 2006 Total Comments: 24
RE: How can you join two tables without using joiner a...
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.