1 Reply Latest reply on Mar 25, 2020 10:43 AM by Anonymous Student

    Can I add a SOQL query inside expression to fetch data from salesforce using informatica cloud

    Anonymous Student Seasoned Veteran

      I have csv file as a source and salesforce as target in informatica cloud. To populate one of the fields on salesforce side, I want to write an IFF expression. If a=true, populate the field with 'xyz' but if a!=true, then run a SQOL query in salesforce, fetch the value and use that value to populate the field.

      Is it possible to use a SOQL query inside the expression in informatica when salesforce is on the target side?