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 are the Differences between connected and unconnected
lookup?

Answer Posted / mayur

Connected Lookup
- In mapping flow (Pipeline)
- One or more output (Multiple return port)
- Can Assigned Default Value
- Have to create new if more than one table to lookup in the same mapping
Unconnected Lookup
- Not in mapping flow
- Only one output (Single return port)
- Can’t assign default value
- Can use multiple time

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which are the different editions of informatica powercenter that are available?

1034


What are the prerequisite tasks to achieve the session partition?

1252


What is the status code in stored procedure transformation?

1182


What is a joiner transformation?

995


how to load dimension table and fact table. plz tell me the steps.

2094


Does an informatica transformation support only aggregate expressions?

1042


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2720


Explain load alternative records / rows into multiple targets - informatica

1152


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2182


Clarify the aggregator change?

1028


What is mapping debugger?

1012


What is complex mapping?

1120


Design a mapping to load the cumulative sum of salaries of employees into target table?

1505


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1128


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 ?

1664