Which value is replicated or loaded from the picklist custom field in Salesforce?
Consider a picklist called Fruit. It has the following value set in Salesforce:
- Value 1: Text Value:
1st option; API Name:
- Value 2: Text Value:
2nd option; API Name:
- Value 3: Text Value:
Non-applicable; API Name:
The value that you will see in the data warehouse will be the API name.
Following the example above, the values loaded to the warehouse will be: