i have configured the user profile syncing with my custom SQL table. i require 4 properties that are with 6 columns in the table
& the scenario is i have to concatenate the strings of the 3 columns of sql table in one property of user profile.
say sql structure is like
customer_id number(10) not null,
customer_name varchar2(50) not null,
state varchar2(25), zip_code varchar2(10),
i want to map address property of user profile with string = address + city + state
please suggest any way to achieve this .