While creating a field map for a reference field in the Transform Map, we generally give a value in the 'Reference field value', however if we miss it (intentionally or otherwise) how would the mapping happen?
Well, when the value is not given, we would assume that probably it would try to match the sys_id of that reference field while trying to associate the reference field during the runtime transformation, but that's not the case- in fact the reference table's display value that is used for a match or association, which would mostly be the number or the name of the record...
FYI, heads-up, you've been warned!
