This video explains connected lookup in PowerCenter.
See the below link for part-1 of lookup:
https://www.youtube.com/watch?v=nsLCi4dPegE
Expertise: Advanced
User Type: Developer
Category: Developer
Project Phase: Implementation
Problem Type: Implementation
How to automate the repository and domain back up process for disaster recovery in PowerCenter
How to find in which host the Repository Integration service is running in a multi node domain
Converting and adding of a self signed certificate to use a Webservice Consumer transformation