Transform map onBefore event versus Run Script

[Shrikant Pathak]

Hi friends,

I am writing transform map script onBefore() :

(function runTransformScript(source, map, log, target) {

    if(target.u_request_frequency!=''){

        ignore = true;

    }

})(source, map, log, target);

Now, the doubt is :

Shall I write this script in Run Script or onbefore() since it will give same result in both the cases ?

Please suggest.

Your help will be appreciated.

[Stefan Georgiev · Accepted solution]

Hello @Shrikant Pathak,

I was asking myself the same question a few months ago. It really depends on what your case is. Based on one KB article - Transform Maps - Order of execution

Resolution

1. Run the onStart script
2. Find the target record by evaluating all coalesce field maps/scripts. 
   
   • Before any other scripts are executed, the target record is found.
3. Run the onBefore script. 
   
   • Since this is executed after finding the target record, you need to make sure the coalesce scripts do not depend on any variables defined here in the onBefore script. 
4. Transform all field mappings. 
5. Run the main transform Run script. 
   
   • This is the main script in the transform map which is visible only when "Run Script" is checked. 
6. Run the onAfter script.
7. Repeat 2-6 for all import set rows. 
8. Run the onComplete script. 

I think that you need to check at what point of the execution of the transform map you want the script to be executed, and yes they are going to do basically the same.

Hope that this helps you!

If the provided information answers your question, please consider marking it as Helpful and Accepting the Solution so other community users can find it faster.

All the Best,
Stefan