What is diff between connected and unconnected lookup?

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is mean by complex business rule ?

1727


how many types of dimensions are available in informatica?

571


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1869


Explain what transformation and how many are there in informatica?

501


how we can load rejected record's at run time?(not through bad files)

1915






Explain the different dimensions.

566


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

615


Why is sorter an active transformation?

672


What are the types of schemas we have in data warehouse and what are the difference between them?

536


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

800


What are the different types of olap? Give an example?

570


what are the Methods For Creating Reusable Transformations?

660


What happens when a session fails and you click on recover?

669


What is InformaticaPowerCenter?

702


What is status code in informatica?

594