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

[apmcarmosilva]

This is very accurate and helpful information. Thank you!

The detail on coalesce fields being run before the "onBefore" scripts is very important. I ended up in this thread because of that 😉

[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