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 are the components of workflow manager?

0 Answers  

Which is better performance wise database or file?How?

2 Answers   TCS,

differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,

How we can create indexes after completing the load process?

0 Answers  

can every transfomation reusable?how?

2 Answers   Wipro,

Enlist few areas or real-time situations where informatica is required.

0 Answers  

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

What are the types of caches in lookup? Explain them.

0 Answers  

Do you have knowledge in ralph kimball methodology

1 Answers  

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,