What is the order of execution - Before BR or OnBefore Transform script

[Dolly M]

Hi,

We have a transform map created on incident table for a specific use case. The assignment for the inserted incident records happens via OnBefore transform script. 

Now, we also have a new before insert/update BR on incident table, which sets the assignment group.

Which assignment group will be set at last ? group set via transform script or group set via before BR ?

Regards,

Shraddha M

[Dolly M]

Run business rules is checked on the transform map record

[Ankur Bawiskar · Accepted solution]

@Dolly M 

If the Run business rule is checked then as per my understanding the group from BR will be populated the last.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[PriyaRanji]

Hello @Dolly M , If the run business rule is checked in your transform script then the assignment group set based on your business rule else the assignment group get set based on transform script.

Thanks,

Priyanka R

[JaishreeR]

Hi @Dolly M 

When importing data into a target table, the OnBefore Transform script adjusts the data at the staging table level, while the Before Business Rule processes the finalized data right before it is stored in the target table.

If my response was helpful, please mark it as correct so it can be valuable to others.

Thanks 

Jaishree R