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.

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,

How to differentiate between the active and passive transformations?

0 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

How many repositories can we create in Informatica??

9 Answers   IBM, Patni,