Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Under what condition selecting sorted input in aggregator may fail the session?

1057


can we override a native sql query within informatica? Where do we do it?

1068


What are the different options available for update strategy?

938


How can repository reports be accessed without sql or other transformations?

1158


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1605


Explain in detail scd type 2 through mapping.

987


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

991


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5561


What is a router transformation?

1047


How many number of sessions can one group in batches?

1093


What is decode in informatica?

1072


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1047


What all are steps in up gradation of Informatica server?

988


How to join three sources using joiner? Explain though mapping flow.

1090


What is the difference between source qualifier transformations source filter to filter transformation?

996