The Fields tab displays the fields that are read from the Salesforce module selected on the Settings tab. You will need to go to the Fields tab and press the Get Fields button to populate the fields returned before you can preview the rows returned.
The following are the properties display in the Fields tab.
| Option | Description |
|---|---|
| Name | The name of the input field. |
| Field | The name of the field that contains the record. |
| IsIdLookup? | Specify if the field will be used as a fieldname ID (links to an External ID) when accessing the database to perform other calls, such as delete, insert, update, and upsert. Select ‘Y’(Yes) or ‘N’(No). |
| Type | The data type of the field. |
| Format | An optional mask for converting the format of the original field. |
| Length | The length of the field depends on the following field types: |
| Precision | Number of floating point digits for number-type fields. |
| Currency | Symbol used to represent currencies. For example: $ or € |
| Decimal | A decimal point can be a . or , (5,000.00 or 5.000,00 for example). |
| Group | A grouping can be a , or . (5,000.00 or 5.000,00 for example). |
| Trim type | The trimming method to apply to a string. Trimming only works when no field length is specified. |
| Repeat | If the corresponding value in this row is empty, repeat the one from the last time it was not empty. Select Y(Yes) or N(No). |
See Understanding PDI data types and field metadata to maximize the efficiency of your transformation and job results.