Use parent transform map for record of child tables

Hi.

Hi have a parent table and six child tables, and I need to import data into ServiceNow from different Excel sheets.

Now I was thinking about creating a single transform map for the fields of the parent table and then creating another transform map, one for each subclass, to run on top of the other to add the fields of the child table to the record.

The thing is, if I run the parent transform map first I am going to insert the record in the parent table, and then I would need to reclassify the record in the correct subclass (by the way, is that possible?).

I could run the transform map first, but then maybe I could have some mandatory fields missing from the parent and I would already have created the record.

These were the first ideas I came up with to tackle this import.

Do you have any other idea for a clean and maintainable solution?