Returning multiple values as single value from lookup in informatica cloud -

i passing emp_id lookup argument. want return first name , last name lookup in single column(i.e. full_name).

we can achieve in informatica powercenter concatinating 2 values. can tell me how achieve in informatica cloud.

return port should work this.

full_name(return port)=concat(first_name,last_name)

thanks in advance.

is lookup data in database or on salesforce?

if lookup data in database , create view on lookup table data require.

if lookup data on salesforce, create salesforce object field concatenated value. make invisible on ui.

hope helps.