I am trying to build a process which writes to Oracle database and wanted some pointers.
In Oracle I have a Header table and Details table. For a given Header record, there could me multiple Detail Records.
My process should write one Header record in Header table and then insert corresponding detail records in details table. Go back enter another header record and then insert details records so on. The two tables have a common key called ID.
If there is a failure inserting a particular header record, details records should not be entered for that header. If Header record is inserted, but for some reason details records fail to be inserted, Header record should be rolled back or rather fail.
How could I achieve this in Boomi? Can someone please give me some pointers?