Hi,
I am using Robust Transform Map to map data source to CMDB computer table.
Now, we have a mapping for Manufacturer information where staging contains a string (manufacturer name), what I am doing is checking ServiceNow core_company table if the manufacturer present or not (via name) and if present then returning SysID of the record. Then I have mapped the SysID with CMDB Computer table's 'manufacturer' field (it's a reference field to core_company). But what's happening is instead of referencing the correct record, it's creating another record where name = SysID and referencing that one.
It's an odd issue and I am unable to figure out why it's happening as usually passing sysid to reference field is the way to go.
Please suggest.
Regards,
Debjit
