Currently, Centerprise DI lacks functionality that allows for users to parameterize Database Table Destinations by using a "WHERE" clause to apply specific updates. This is particularly pertinent in scenarios where a developer does not need to apply an update all throughout the table and cannot be reconciled by matching IDs alone. This should also decrease I/O and overall overhead by making the update more efficient/precise.
Right now, the update process looks like something like this:
- UPDATE TableA
- Set ColumnA = ValueA
- Where TableAID = ?
OR like this:
- Update A
- Set A.ColumnA = ?
- FROM TableA A
- JOIN SourceB B
- ON A.ID = B.ID
What I am proposing allows for this:
- Update A
- Set A.ColumnA = ?
- FROM TableA A
- JOIN SourceB B
- ON A.ID = B.ID
- WHERE ColumnB = X