Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

what is the difference between lookupoveride and joiner?

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

How can repository reports be accessed without sql or other transformations?

0 Answers  


1 Answers   Patni, TCS,

Clarify the aggregator change?

0 Answers  

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  

can you use flat file for repository?why?

2 Answers   TCS,

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

What are the scheduling options to run a sesion?

2 Answers