Informatica - What is the difference between using Joiner and Using Lookup to join to tables. Which is good to use

Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 93 of 301

Print

What is the difference between using Joiner and Using Lookup to join to tables. Which is good to use.

Total Answers and Comments: 5

Last Update: October 20, 2007 Asked by: Naveen Kumar

Sponsored Links

Best Rated Answer

—

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

November 02, 2006 02:48:20

#1

Member Since: November 2006 Contribution: 3

RE: What is the difference between using Joiner and Us...

Lookup can be used instead of joiner when the data is coming for same source database platform.

Joiner can be used when data is coming from hetrogeneous databases.

Is this answer useful? Yes | No

February 13, 2007 23:59:54

#2

Member Since: December 2006 Contribution: 17

RE: What is the difference between using Joiner and Us...

only we can use the joiner transformation when we are retrieving the data from same source database.But we are using the joiner transformation when we are retrieving data from multiple or hetorogeneous databases.

Is this answer useful? Yes | No

February 14, 2007 03:39:20

#3

sai

RE: What is the difference between using Joiner and Us...

joiner is used to join the data from hetrogenious database plotforms or from the same plotform.lookup is used to join the data from relational database .if u want to join the all columns data from different tables having a common column from hetrogenious database plotforms or from the same plotform joiner is preferable.if u want to join the data in perticular columns from relational database it is preferible to use lookup transf, it will improve the session performance .

Is this answer useful? Yes | No

October 15, 2007 08:52:47

#4

Member Since: October 2007 Contribution: 2

RE: What is the difference between using Joiner and Us...

The exact difference is, by using joiner we can get both matching and unmatching records from the table .

By using look up we can find out whether the records exists or not.

and other thing we can use logical operators such as >,<,<= in look up.

we cant use logical operators other than '=' in joiner...

Is this answer useful? Yes | No

October 20, 2007 04:48:22

#5

sai kiran

RE: What is the difference between using Joiner and Us...

If possible using Lookup will give better performance over joiner.

Using lookup we can performÂ outer joins, equi, and non equi joins.
Using joiner we can perform only equi joins.

In lookup we can also write SQL ovverrides.

Is this answer useful? Yes | No

Sponsored Links

Informatica FAQ Related

—

Sponsored Links

About Us | Privacy Policy | Terms and Conditions | Contact | Site Map | Add Question | Propose Category | RSS Feeds | Articles Sitemap | Site Updates | Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved