Integrationhub ETL Inserts / Updates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2025 04:43 AM - edited 05-12-2025 09:36 AM
Hi All
In Integrationhub ETL, what is the best way to target the parent cmdb fields and child cmdb fields at the same time.
At the moment I have 1 conditional class that's mapping to cmdb parent table and maps 15 fields and sets the classes from the file. Then another conditional class that has 20 odd If conditions with the child class, these then map to 1 to 3 fields max.
This all works fine, however they do not run at the same time, which I understand, so if it's an Insert, I get Insert also an update for the same record. If it's an update I get 2 updates.
The only way I can think that of rather than do it this way is having all fields mapped in each child conditional class, then the last Else Class would be the parent which would just have the 15 fields mapped.
Is this the best approach, albeit a pain to replicate the mapping of fields for 20 odd child classes or is there a better way to achieve this.
Thanks