PowerExchange for Salesforce User Guide for PowerCenter

10.4.0
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1

Back Next

Salesforce Lookup Query

The input and output ports in a Salesforce Lookup transformation determine the sforce Object Query Language (SOQL) query used in the lookup. The SOQL language is a derivative of SQL. The PowerCenter Integration Service generates a separate SOQL query for each row that passes into the transformation. The port values for each row determine the values used in the query.

The PowerCenter Integration Service generates SOQL queries according to the following rules:

A lookup port is a port that you import from a Salesforce object and connect in a mapping.

All lookup ports must match the Salesforce field name and have an associated Salesforce datatype.

The PowerCenter Integration Service generates the SELECT statement based on the connected lookup output ports.

The PowerCenter Integration Service generates the WHERE clause based on the connected lookup input ports and the LKP_FILTER port.

The PowerCenter Integration Service matches rows based on equality with the connected input port values and, if applicable, based on an additional filter condition.

For example, a Salesforce Lookup transformation is based on the Salesforce object named Account. The connected lookup input ports are Id and AccountNumber. The connected lookup output ports are Id, Name, and Phone. The SOQL SELECT statement has the following format:

SELECT Id, Name, Phone FROM Account WHERE Id = '<value of Id>' AND AccountNumber = '<value of AccountNumber>'

When you use the SOQL query with the Filter transformation or Expression transformation, the Data Integration Service ignores the SOQL query.

Rename Saved Search

Table of Contents

PowerExchange for Salesforce User Guide for PowerCenter

PowerExchange for Salesforce User Guide for PowerCenter

Salesforce Lookup Query

Salesforce Lookup Query