dot mapping on Transform Map

[kironk]

I am trying to create transform map for server-application relationship mapping.

However, I would like to match the server class (child.class) from source to target. But I am unable to dot map to taget table for child.class or Parent.class.

How do I do that  ?

[Tony Chatfield1]

Hi, for a record update you should be able to dot.walk to an already existing reference field;
But for a new record the relationships do not exist, and I think you would need to script a gliderecord lookup, either in the field map or in a before transform script. My preference is to keep all scripting (not required by coalesce) in a before transform script, so that there are no hidden surprises for future developers, this also often makes the solution more efficient as results from a gliderecord lookup may be leveraged during the population of multiple fields.