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

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 530 of 631

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

Total Answers and Comments: 3

Last Update: December 17, 2007 Asked by: Saumya

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

May 07, 2007 22:48:49

hanug

Member Since: June 2006 Contribution: 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.

Is this answer useful? Yes | No

September 24, 2007 13:23:16

chandrarekha

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

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

Is this answer useful? Yes | No

December 17, 2007 12:25:10

senthilkar

Member Since: December 2007 Contribution: 3

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

If the sources are homogenous, we use source qualifier
if the sources have same structure we can use union transformation

Is this answer useful? Yes | No

Go To Top