Discussion

2
Replies
743
Views
PradeepG7936 Member since 2015 26 posts
CVS
Posted: 5 years ago
Last activity: 4 years 3 months ago
Closed

Data Propogation Vs SOR approach

Hello,

 

I have  a parent case and I capture the client information in the parent case. Now I will have a bunch of child cases which might need to use that client information which is present in the parent case. Now  I have three approaches.

 

  1. Propagate the client data from parent to child on instantiation.
  2. Directly refer to the parent data from the child.
  3. Use an SOR approach store the client data in a separate table after capturing the client data at the parent. Propagate the SOR key to  the children, and use that key to refer/modify that client information.

I feel third option is best, but there are two types of clients one with Class/Dept  as key and another one as Class/Dept/Div as the key, now how do I form the key as Div will be blank for the first type of client. In that case I should just use a Serial number as the key, and manually making sure this serial number is unique when we add each client.

 

Thanks,

Pradeep

Data Integration
Moderation Team has archived post
Share this page LinkedIn