What is diff between connected and unconnected lookup?

Answer Posted / 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.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the command used to run a batch?

663


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1720


Differentiate between a database and data warehouse?

752


What is powercenter on grid?

813


Explain the features of connected and unconnected lookup.

639






Can we create a node as a gateway node and the same node can be assigned to a grid?

727


Does an informatica transformation support only aggregate expressions?

699


what are 3 tech challenges/ common issues you face?

1980


Where is metadata stored?

700


What is session task and command task?

739


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1622


What is meant by lookup transformation? Explain the types of lookup transformation?

652


Separate from an archive server and a powerhouse?

579


Explain where to store informatica rejected data? How to extract the informatica rejected data?

693


Which is the t/r that builts only single cache memory?

821