Answer / prasanna

Joiner is active transformation in informatica to merge
nonsimilar structures into target warehouse systems.
Joiner needs a condiotion for data merging based on
following types
1.Normal join
2.Maste outer join
3.Detail outer join
4.Full outer join
Lookup is a passive transormation in informatica.this
transformation is used for data verfications of the source
table in assign lookup table
Lookup needs a condition if the condition is satisfied
returns corresponding data else returns null value.

Answer / shiva shankar naidu n

1.Join supports all types of joins, but lookup supports only
two types of joins supports like inner and left outer only..
2.join not provided rejected link, but lookup provided it.
3.join is high sorting speed but not lookup.
4.join takes huge amount of data from two tables, but look
up not supported to data than source table.
5.In lookup Reference data always less than source data
other wise its not suppoted.
6.lookup always based on condition, but not join stage.
7.join common column must be same, in look up no need common
column name.

Answer / kittu

hi every one

i read all the answers i agree with you but one more thing is there in joiner. once u specify d joiner it will extract all the data from source and check the based on condition then it returns values.

in look up it wont take any values but it refers based on condition.It means look up check the values present r not.
here main thing is memory if cache size is increase it decrease the informatica performance.same thing will happen in joiner trans so mostly we r not using joiner but some times based on source data we use.

Answer / krishna

I) Joiner is active transformation & lookup is passive
transformation.
2)joiner having input port,output port, master port where as in lookup having input port, output port,lookup port,return port.
3) joiner having sorted inputs option where as lookup doesent have this option

Answer / shiva

Joiner transformation:

it has its own cache.

look up transformation:

it maintains its own cache

Answer / guest

If you are not a performance geek, somewhat basic things
you can do with both joiner and lookup t/f. However Joiner
operates on sources where as lookup operates source as well
as target. there are other things can also be identified as
limitation of working with heterogenious sources in both
the case.(can lookup work on xml file?)

What is Index Caches size?

0 Answers   Informatica,

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

How will you convert rows into columns or columns into rows

1 Answers  

In any project how many mappings they will use(minimum)?

1 Answers  

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

What is an expression transformation in informatica?

0 Answers  

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

What are the informatica performance improvement tips

0 Answers   Informatica,