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?)

How would you copy the content of one repository to another repository?

0 Answers  

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

What are the different types of repositories created using informatica?

0 Answers  

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers