Table of Contents

Search

  1. Preface
  2. Understanding PowerExchange for Salesforce
  3. Configuration
  4. Salesforce Sources and Targets
  5. Salesforce Lookup Transformation
  6. Salesforce Merge Transformation
  7. Salesforce PickList Transformation
  8. Salesforce Sessions and Workflows
  9. Appendix A: Datatype Reference
  10. Appendix B: Glossary

PowerExchange for Salesforce User Guide for PowerCenter

PowerExchange for Salesforce User Guide for PowerCenter

Salesforce Lookup Ports

Salesforce Lookup Ports

You can include the following types of ports in a Salesforce Lookup transformation:
  • Lookup ports.
    You import the lookup ports from a Salesforce object definition when you create a Salesforce Lookup transformation. The PowerCenter Integration Service uses lookup ports to generate the lookup query.
  • Pass-through ports.
    You can add pass-through ports to the transformation. The PowerCenter Integration Service passes these port values unchanged through the transformation.
  • Default ports.
    When you import a Salesforce object definition, the Designer creates default ports named LKP_FILTER and LKP_MATCHIDX. You can use the LKP_FILTER port to add a filter condition to the lookup query. The PowerCenter Integration Service uses the LKP_MATCHIDX port to assign sequence IDs to matched rows.

0 COMMENTS

We’d like to hear from you!