what is the difference between lookupoveride and joiner?

Question Posted / navya

3 Answers
7854 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference between lookupoveride and joiner?..

Answer / nikhil

Using lookupoverride u can join two relational tables but
not flat files . Joniner T is used to join two heterogenous
sources like relational tables from two different databases
or flat file sources.

Is This Answer Correct ?

3 Yes

2 No

what is the difference between lookupoveride and joiner?..

Answer / kotesh

using lookup override we can join more two table either it
is relational or flatfiles also. and one more advantage is
it supports orderby condition.
but jointrns we can join two tables.

Is This Answer Correct ?

0 Yes

0 No

what is the difference between lookupoveride and joiner?..

Answer / joshasmita

Using Loopoverride we can join two relational tables but
from same database. With joiner we can two sources of
different types

Is This Answer Correct ?

2 Yes

3 No

Post New Answer

More Informatica Interview Questions

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers Amdocs,

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers

How to load last n records of file into target table - informatica

0 Answers Informatica,

what is the use of Data Mart?

5 Answers IBM,

Why update strategy and union transformations are active?

0 Answers

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers BirlaSoft, IBM,

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

5 Answers TCS,

When the informatica server marks that a batch is failed?

1 Answers

List the transformation in informatica.

1 Answers TCS,

Write the prerequisite tasks to achieve the session partition?

0 Answers

For more Informatica Interview Questions Click Here