How to stop to insert new record and just to allow to update the record in transform map

Go to solution
kambleneeta20
Giga Expert

‎03-19-2019 05:59 AM

Hi experts ,

 

In transform map how can I stop inserting new record and and to allow to update only to the existing record.

How to achieve it?

Please suggest ? thanks in advance.

0 Helpfuls
  • 17,314 Views
1 ACCEPTED SOLUTION

Go to solution
dj7887
Tera Expert

‎03-19-2019 06:06 AM

Hi Neeta,

1) You can set Colease is "True" fr Unique field so that it will not create duplicate records an update existing one.

2) If you want to completely disallow insert then On your Transform Map Click On "Run Script" and use below code.

if (action == 'insert' ){
 ignore = true;
 }

Thanks,

DJ.

View solution in original post

5 REPLIES 5

Go to solution
raja11
Giga Contributor

‎03-19-2019 06:42 AM

Hi

 

By selecting the Coalesce, it won't create new records into a table. Just it works for update the record only.  [for best practice apply coalesce on Unique fields like Ids,....). I think this is only the option. Or

 

Using Transform Scripts: in

if(action=='insert')

{

ignore=true;

}

 

Regards

Raja

0 Helpfuls