Is it possible to access scratchpad in transform scripts??

asoni1
Kilo Contributor

‎08-12-2019 11:02 PM

Is it possible to access scratchpad in transform scripts??

I have a requirement, where in I need to compare target table records with the input records and mark the unwanted records in target table as inactive 

 

Please recommend.

0 Helpfuls
  • 1,722 Views
10 REPLIES 10

DirkRedeker
Mega Sage
In response to asoni1

‎08-14-2019 08:34 PM

Hi

It is a good idea, to minimize database impact on any activity done. Anyhow, if you want to check on record level, you have to walk one by one.

You could improve overall performance, if you can run the import on non business hours. 

BR 

Dirk 

0 Helpfuls