Insert records into Recipient and Custom Table

[#1]

Hello,

We are using the Recipient table to store the customer attributes and also created a custom table to store several customer extension attributes. This is a 1:1 relationship.

I'm trying to insert records into the Recipient and the Custom table in a single workflow. Is this possible or do i need separate workflows for each Target dimension?

Any other suggestions on how to insert records into Recipients and the Custom table??

Thanks for your help

Sree

[#2 · Accepted solution]

Use reconciliation on key, or straight insert (no update) if that’s your use case.

[#3]

Hi,

Have the 'Update data' activity for nms:recipient output a transition, then connect it to a 2nd update activity for your custom table.

The outgoing transition will have the pk's of the upserted nms:recipient rows to use for your custom table's recipient-id fk.

If the relationship is the other way (recipient table has fk's to custom table), reverse the above order.

Thanks,

-Jon

[#4]

Straight Insert worked. I'll add the reconciliation step too. Thanks for your help

[#5]

Thanks Jon.

I tried the approach and running into this error message. Do we need to perform any transformation before the 2nd Update activity?

06/26/2019 5:38:48 PM writer2 WKF-560029 The document types of inbound events ('srm:Custom' and 'nms:recipient') are incompatible (step 'Insert Recipients'). Unable to perform the operation.