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

[kambleneeta20]

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.

[Varsha21]

Hi

apply colease on unique field as true.

and in script 

if(action==insert)

ignore=true

varsha

[dj7887 · Accepted solution]

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.

[kambleneeta20]

thank you.

[amar7]

Hi 

i want it quit opposite if the record exist in the target table then it should not update the record based on serial number

if the serial number record is available in the target table then don't update the record 

if the Serial number record is not available then insert the record .

Will this work 

in run script:

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