1 of 1 people found this helpful
Have you checked below ?
I understand that it is difficult to check with 30 million records but if you test it with 30 records then everything will be clear
1) Start with sample 30 records (test )
2) Manually add additional records after every hour (you can check for 2-3 times )
3)Check if your calculation is working or not ?
Ah.. Part 3. Incremental load for UPSERT operations to underlying data model is pretty much identical to the solution i ended up with. I really should have asked sooner.