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?
I guess my first question is can I run a SOQL query in place of a lookup in informatica, since lookup is much simpler than what I am trying to achieve. I need to look at various different fields in salesforce and then return a value?