I have a requirement to load data from a single Import Set Table into three different CMDB classes: Data Center, Computer Room, and Data Center Zone. The target class should be determined based on a field value in the Import Set Table.
Can someone guide me on:
- How to configure a Robust Transform Definition to route records to different CMDB classes based on a field value?
- How does the data flow from the Import Set Table to the target CMDB tables in a Robust Transform?
- Is a separate Staging (STG) table required, or can the Import Set Table be used directly in the Robust Transform Definition?
- What would be the recommended best practice for this scenario?
Any examples or guidance would be greatly appreciated.
Thanks.
