Answer / padmavathi

Connected Lookup:
Part of the mapping dataflow.
Returns multiple values by linking output ports to
another transformation
Executed for every record passing through the transformation
More Visible, shows where the lookup values are used.

Unconnected Lookup:
Seperate from the mapping dataflow.
Returns one value by checking the return port option for
the output that provides the return value
only executed when the lookup function is called
Less visible, as the look is called from an expression
within another transformation
Default values are ignored

Answer / venkatesh reddy

connected lookup:

It is used to join the two tables
it returns multiple rows
it must be in mapping pipeline
u can implement lookup condition
using connect lookup u can generate sequence numbers by
enabling dynamic lookup cache.

unconnected lookup:
it returns single output through return port
it acts as a lookup function(:lkp)
it is called by another t/r.
not connected either source r target.

Answer / kalu bhai

CONNECTED look up:
>> It will patispated in data pipeline
>> It contain maltible inputs and maltible outputs.
>> It supported flat file and relation table
>> It supported static and dynamic cache.

UNCONNECTED LOOK UP:
>> It will not patispated in data pipeline
>> It contain maltible inputs and single output.
>> It supported relation table only
>> It supported staticcache only.

Answer / ramesh

the main difference between connected and unconnected is

connected:
recieves data from source table in a pipeline.
it returns multiple columns
it supports user defined default values
unconnected:
recieves data from result of the lookup expresion on other transformation
it returns one column
it doesnt supports use defined default values

Answer / naidu.k

Connected Lookup
Its can recieve multiple input ports and returns
multiplepoutputorts
it is part of mapping data flow
when lookup condition no match Data the integration services
returns insert the data
when lookup condition match Data The integration services
returns update the Data
default values supports
UNConnected Lookup
Its not part of mapping data flow it can recieve multiple
input ports and return single output ports.
when lookup condition no match data the integration services
returns null values
when lookup condition matchdata the integration srvices
returns update data
default values removed
I

What is the difference b/w natural key and surrogate key

1 Answers  

Explain target update override in informatica

0 Answers   Informatica,

what is update strategy transformation ?

7 Answers   TCS,

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

In how many ways we can create ports?

0 Answers  

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

Why we use partitioning the session in informatica?

2 Answers  

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

Define enterprise data warehousing?

0 Answers  

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers