Based on my project requirement ,I need to get UID_Org value from the Org table (Destination) on the basis of the value present in the column RoleName which is present in my source table .....
To Achieve the above requirement
Step 1: I have created a virtual property vrtSourceRoleName of type fixed value in the Sync Editor and assigned the RoleName(column from Source table) to it.
So that I could get UID_Org value from Org table satisfying the condition ident_org=vrtSourceRoleName
Step 2 : created a virtual property of type - key resolution by reference and wrote the query to retrieve uid_org from org where ident_org=vrtSourceRoleName
Please let me know if I'm correct with the implementation
Thanks in Advance