You need to sign in to do that
Don't have an account?
Mahesh@sfworld
update a LOOKUP field on child object with relationship to parent object
Hi Everyone,
we have a integration environment Between DataStage and Salesforce .Currently we are using data loader script (process xml) file with the reference to mapping file for "upsert operation ".my requirement is to establish a relationship between Bond (at parent object) to a Coverages(child object ) ..There is a Bond field on child object defined as "Lookup(Bond)"..In mapping file,for updating LOOKUP (I.e.Bond) field on child object (i.e Coverage)..I have defined as below
Example :Initially Parent Object "Bond" is created with ExternalID =1234 .After that Child object "Coverages" lookup field "Bond" is updated with value Bond_ExternalID=1234" .So this way coverages are linked to the Bond (Parent object).
For the same scenario mentioned :
We would like to use "salesforce pack for datastage " .How can I define a mapping for child object (Coverages) so that (Bond) Lookup field for upsert operation is updated with Parent Bond record (Parent externalID)?
Please let me know the resolution how can I achieve above requirement to work it properly.
Thanks,
Dev
we have a integration environment Between DataStage and Salesforce .Currently we are using data loader script (process xml) file with the reference to mapping file for "upsert operation ".my requirement is to establish a relationship between Bond (at parent object) to a Coverages(child object ) ..There is a Bond field on child object defined as "Lookup(Bond)"..In mapping file,for updating LOOKUP (I.e.Bond) field on child object (i.e Coverage)..I have defined as below
Bond__r_ExternalID__c=Bond__r\:ExternalID__cWith the above mapping "Bond"field (CHILD object field )is getting updated with ExternalID of Bond record (Parent externalID)
Example :Initially Parent Object "Bond" is created with ExternalID =1234 .After that Child object "Coverages" lookup field "Bond" is updated with value Bond_ExternalID=1234" .So this way coverages are linked to the Bond (Parent object).
For the same scenario mentioned :
We would like to use "salesforce pack for datastage " .How can I define a mapping for child object (Coverages) so that (Bond) Lookup field for upsert operation is updated with Parent Bond record (Parent externalID)?
Please let me know the resolution how can I achieve above requirement to work it properly.
Thanks,
Dev
Thanks.
As per the present functionality of the Salesforce Stage of Information Server, for a Parent-Child Relation, the Child Record can be upserted using either the External ID of the Parent Object or the ID of Parent Object.
For example, for an object "PARENT", for one record we have the fields "ID" as "a2s2G000004FnRkQAK" and the "External ID" as "ExtPARENT00001", then we can load data into the Child Object, for example "CHILD01" using either the "ID" field or the "External ID" of the Parent Object
The record can be loaded into the Child Object (CHILD01) with the data and metadata as follows
(a) "ExtIDCHILD0001"( External ID CHILD01), "John" (Name CHILD01),"a2s2G000004FnRkQAK" (ID - PARENT)"
or
(b) "ExtIDCHILD0001"( External ID CHILD01), "John" (Name CHILD01),"ExtPARENT00001" (External ID - PARENT)"
The example (b) as mentioned above must meet your rerquirement as I understand. If not, please let us know what is required
Regds,
Deepak