To lookup Salesforce table from Informatica Power Center, you need to use Salesforce lookup transformation. Regular Lookup transformation cannot be used.
Details
- Add Salesforce lookup transformation in mapping. In dialog box that appears, enter the user name, password and service url.
- After connecting, choose the object you would like to lookup and click Ok to import.
- Lookup ports
- You can keep the lookup ports you need and delete others.
- All connected lookup ports will be included in SOQL Select statement which would be generated by Integration service
- Default ports
- LKP_FILTER - You can pass filter condition to this port which will be added to the Where clause of Lookup SOQL.
- LKP_MATCHIDX - unique sequence id of match
- 0 => when no matches found
- 1 - n => 1 for first match found, and 2 if second match is found etc..
- Lookup input ports
- Input ports can be configured so those would be added in SOQL where clause
Notes
- Salesforce lookup transformation returns multiple matches by default
- There is no cache - Integration services generates SOQL statements based on each input row
- Use Source Qualifier and Joiner instead if you would like to cache Salesforce lookup data
- There is no query overriding
-
No comments:
Post a Comment