Transform Map inserts multiple records in user table!!

[Rakhesh]

Hi Guys,

We are troubling with one issue using transform map. Briefly, We are getting the data form database view by using transform maps we are insert into user table.So we gave Coalesce to one unique field, still we are getting duplicate records in user table.

we are noticing the issue i.e., example if user has a different emails then it is inserting into user table.we have an unique email i'd and ending with our 'company name'. So we need only those records. How we can achieve this ??? 

Thanks,

Rakhesh

[rammohanraomadd · Accepted solution]

Hi Rakhesh,

Please mark it as correct or helpful if the issue is resolved.

Regards,

Ram M