Hi,
Why should a real-time pipeline wait for 10,000 rows before updating a database?
And why should Teradata execute thousands of individual UPDATE statements when it can process them as a set?
I wasn't satisfied with either approach.
So I built my own Teradata MERGE solution for Apache NiFi.
The idea is simple:
If 100,000 rows arrive within a few milliseconds, process them together using one optimized MERGE.