Is there a way to create a composite key in the process in order to identify the records in specific?
1) We could use filters in the operation combined by the logical sub group in order to find the records on the basis of the composite key-A combination of two fields.
2) We could Create One index in the Document Cache and add two fields which you feel they form a composite.
Means, one index with two entries in the cache. this would be the composite key by which boomi would store the records on the basis of these two fields. When retrieving use the load from cache and use that index with two entries and you would get all the records that satisfy your composite key.
Note: While storing in to the Add to Cache shape , before storing into it use the business rules shape to check whether those two fields are null or empty . Just choose the operator there as Is Not Empty in the business rules while configuring.
This way we could store only the valid records that have the values for these two fields. Otherwise while loading them we would face the error.
Retrieving data ...