What is the order of execution of Transform map and Business rules?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-11-2023 04:10 AM
After which phase of Transform Map the actual database operation happens?
And also when the 'Run business rule' is enabled on the Transform map, and if there is a conflict for a field (Transform map says to update the field with value as 'A' but business rule says update it as 'B'), what happens?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-11-2023 04:15 AM - edited ‎12-11-2023 04:15 AM
Hi @Suggy
Please find the below links for your query
Thanks & Regards,
Eswar Chappa
Mark my answer correct and Helpful if this helps you 😀

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-11-2023 04:16 AM
Hi @Suggy ,
Each row in the import/excel is considered a record, so if you start importing a record:
1. All before Business Rules will execute before transforming the row to a record.
2. Once record is inserted, all the After BR will execute
Usually using transform map we insert or update the records.
the BR will run at that time. If it's before insert/update then before insertion/update it will trigger.