Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
Effective in version 10.1.1, you can perform a lookup. Use the lookup function to lookup a key column in another sheet and fetch values in corresponding other columns in that looked up sheet.
For more information, see the "Prepare Data" chapter in the