Hello,
I have 2 flows which insert data into the same table let's say table "Customers".
The integration templates generate a temp table named "I_Customers", which is destroyed at the end of the mapping.
If I run the flows in parallel, there is a conflict. I can guess the processes do these operations:
- flow 1 creates I_Customers
- flow 1 integrates data
- flow 2 doesn't create I_Customers, since it already exists
- flow 1 drops I_Customers
- flow 2 crashes during data integration, since I_Customers does not exist anymore!
How can I proceed to make sure that temp tables are unique?