How can I force record updates in a transform map script?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2025 11:53 PM - edited 01-24-2025 12:53 AM
In a transform map, if there is no change between the data in the source table and the target table, it is ignored.
But I want to update the target record even if there is no change in the data.
How do I set this up?
The source table contains only the latest information, while the target table includes both the latest and old information.
After the transformation, I want to delete the records that were not updated as old information.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2025 12:03 AM
Hello @Yuri____
Why you want to do force update even if there is no change over data? What is your use case here? What are you trying to achieve? As doing this you are intentionally affecting performance of instance whenever you receive data over import set table.
If still you want to do this, you can write onbefore script which says but I wouldn't recommend doing so. Do consult with your architect before doing such changes
target.setWorkflow(false); // Disable any business rules or workflows if needed
ignore = false; // Ensure the record is not ignored even if there are no changes
If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.
Thanks & Regards
Viraj Hudlikar.