Tranformation event script vs Explicit Transform map script

Afsar2
Tera Contributor

‎07-07-2023 03:59 AM

I am curious to understand the transform map scripts execution order.

 

As per the docs Import set functionality offers scripting capability at 3 locations.

 

1. Explicit Transform Map script (Executes after row transformation and before DB update) 

2. Field Map Source Scripts (To preprocess the source field values and then map to target field) 

3. Transformation Event script (executes at different stages of transformation).

 

Does any of the script overwrites the logic defined in any other script during the transformation process for single import?

0 Helpfuls
  • 513 Views
1 REPLY 1

Gsada
Tera Contributor

‎03-27-2025 08:54 AM

Hi @Afsar2 ,

 

The main difference between Transformation Event Scripts and Explicit Transform Map Scripts in ServiceNow is when and how they are triggered, as well as what they are used for. Let's break down the differences in simple terms:

 

Transformation Event Scripts:
Purpose: These scripts are used to run custom actions at specific stages of the transformation process (e.g., when the transformation starts, before or after each record is transformed, or when the entire transformation finishes).
Use Case: Setting up, validating, or finalizing actions for the whole process.

 

Explicit Transform Map Scripts:
Purpose: These scripts are written to handle the transformation of individual records as they are being processed. You write these scripts in the Transform Map to manipulate or modify data on a per-record basis before it’s saved in the target table.
Use Case: Handling complex logic for individual record transformation.

if my response helped please mark it correct. Thank you.


Regards,
Dnyandeo,

0 Helpfuls