Sequence of transform scripts?

[Ravish Shetty]

What are the different sequence of transform scripts?

I am interested in

• Big transform map script
• Source script in Field map
• Other transform scripts like on before, on after, etc

[John Rausch]

Thanks for the info. This should be the answer.

[Pooja Devkar]

Hello,

Following is the different sequence of transform scripts : 

1) onStart

2) onBefore

3) Field mapping

4) Run script

5) onAfter

6) onComplete

Regards,

Pooja Devkar

[scottl]

Why is there no mention of business rules, as these too are just as important during the inserting of data from the transform maps?  Where do they fit in the order of process?

[bernyalvarado]

Hi Scott, 

That's a great question. The reason why it wasn't mention is because the question was about the sequence of "transform scripts" and business rules are not part of the transform scripts.

Still, to answer your question... business rules will still run associated with the insertion, deleting or query of a record IF and ONLY IF the ""Run business rule" checkbox is checked. 

In this case, each record transaction effectively taking place could trigger its own set of business associated to the table. This business rules will not run during the transformation period but only when the record has been attempted to be executed in the system. In other words, prior the on After transform script. 

I hope this helps.

Take care and stay safe! 

Thanks,

Berny

[mbourla]

I think what Scott is asking is more like at what point would "before" or "after" business rules run.  Which is a good question.  Haven't actually tried it out myself, but I'm pretty sure "before" business rules would run following all the onBefore transform map scripts + main transform map script.  Because any of those can set ignore = true, and abort the update.

For the "after" business rules, question is do they run before or after the onAfter transform map scripts.  I'd guess they run before the onAfter transform map scripts, but I would need to do some testing/logging to verify that.

There's also the business of order being less or more than 1000 affecting when business rules run.  As described in this Docs page.  Which could potentially apply here, but it doesn't actually mention transform maps on that page so perhaps not.

Regards
Michael