While reading the Big Object related documentation, I was curious as to what does the following statement mean?
- Big objects don’t support transactions including both big objects, standard object and custom objects.
Consider the following scenario:
- External system pushing records into BigObjects (Platform/Enterprise WSDL)
- SOQL to retrieve the records and work off the records to create a custom/standard Sobject record. (Async SOQL not an option because I do not wish to use target sObject to store the retrieved records)
- Update the BigObject using the "insertImmediate" method with a status as "Processed"
You can create and update custom big object records in Apex using the insertImmediate method -- Reference: Documenation - Page 9 Populate Custom BigObject with Apex
Doesn't the above scenario mean that I would be involved in an Apex transaction with custom Objects as well as the Big Objects?