Answer / kalpana

joiner doesnt support nonequi joins where as lookup support
nonequijoin

Answer / amit

joiner is active transformation & lookup is passive
transformation

Answer / chandra

Joiner will join the two different data sources based on a
join condition ,and pass only the rows which satisfy that
condition.discards the remaining rows.

Joiner transformation supports 4 types of joins at
Informatica level
Normal
Master Outer
Detail Outer
Full Outer

LookUp Transformation

Lookup transformation basically for Reference,based on the
lookup condition.when u want some data based on target
data ,will take lookup on that particular table and
retrieve the corresponding fields from that table.
we can override the lookup transformation using the SQL
query.

Answer / gopal

In joiner we can join two heterogeneous sources for entire
records based on a condition.

But in look up only the first value or last value of the
records will be passed if more records matched with that
condition. So only one value will be returned to the
transformation.
EX:
in source : No Name
1 -
Look up table: No Name
1 A
1 B
1 C

Now we can return only A or C in look up.
If we need entire values we must go for joiner. Take that
look up table as source and use joiner. No alternative
solution.

Answer / jayash

joiner transformation does not match for null values where
as lookup transformation matches for null values
joiner transformation supports only equality operator in
condition of join where as lookup transformation can support
<=,>=,=,!= in the lookup condition

Answer / sweta kedia

. I) Joiner is active transformation & lookup is passive
transformation.
II) Joiner operates on sources where as lookup operates
source as well
as target.
III)Joiner doesnt support nonequi joins whereas lookup
supports nonequi join
i.e. joiner transformation supports only equality operator
in condition of join where as lookup transformation can
support<=,>=,=,!= in the lookup condition.
IV) Lookup uses dynamic and static cache where as a joiner
doesn’t.
V) Joiner transformation does not match for null values
whereas lookup transformation matches for null values.
VI) Joiner will do left outer,right outer,normal,full outer
types of joins whereas lookup will do only left outer join.

Answer / mythili

Hi everybody,
Joiner is active transformation whereas lookup is passive
transformation.
Joiner returns only matching records whereas lookup
returns null if there is no match.
In join condition we can give only '=' operator but in
lookup condition !=,>=,<= are all possible.
Joiner will do left outer,right outer,normal,full outer
type of joins whereas lookup will do only left outer join.

Answer / bsgsr

hi, everyone.
lookup is passive whereas is joiner is active.
look up supports non equi joins ilso whereas joiner
supports only equi joins.
lookup joins on either on first value or last value.
lookup uses dynamic and static cache where as a joiner
doesnt
reach me on bsrinivas1213@gmail.com

Answer / eswar

Use the Joiner transformation to join source data from two
related heterogeneous sources residing in different
locations or file systems. You can also join data from the
same source. The Joiner transformation joins sources
with at least one matching column. The Joiner
transformation uses a condition that matches one or more
pairs of columns between the two sources.

Use a Lookup transformation in a mapping to look up data in
a flat file, relational table, view, or synonym.The
Integration Service queries the lookup source based on the
lookup ports in the transformation and a lookup condition.
The Lookup transformation returns the result of the lookup
to the target or another transformation.

The Joiner transformation supports only equi joins and
Lookup Transformation supports equi and non-equi joins

The Joiner transformation lieterally joins two columns
whereas Lookup transformation return a column based on the
condition, but it will not joint two columns.

Answer / swathi naik

I) Joiner is active transformation & lookup is passive
transformation.
II) Joiner operates on sources where as lookup operates
source as well
as target.
III)Joiner doesnt support nonequi joins whereas lookup
supports nonequi join
i.e. joiner transformation supports only equality operator
in condition of join where as lookup transformation can
support<=,>=,=,!= in the lookup condition.
IV) Lookup uses dynamic and static cache where as a joiner
doesn’t.
V) Joiner transformation does not match for null values
whereas lookup transformation matches for null values.
VI) Joiner will do left outer,right outer,normal,full outer
types of joins whereas lookup will do only left outer join.

what is degenerated dimension

6 Answers   Cap Gemini,

How to do unit testing in informatica?

0 Answers  

Difference between task flow and linear task flow

0 Answers  

What do you mean by worklet?

0 Answers  

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

wf dont have integration severances how you can run?

0 Answers   TCS,

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

what is the diff b/w union and joiner and lookup?

4 Answers  

How to load a Dimension ? and how to load a fact table?

0 Answers  

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

What is mapplet in informatica?

0 Answers  

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,