3 ms·
Back in my DBA days, I used the MSSQL equivalent, "Linked Servers", to set up regularly scheduled ETLs. It's a nice way to reason about tables since you can tes
by SOLAR_FIELDS 6y ago
Back in my DBA days, I used the MSSQL equivalent, "Linked Servers", to set up regularly scheduled ETLs. It's a nice way to reason about tables since you can test your joins in real time. The only real implication here is performance, as someone else mentioned in another comment, joins can be quite slow. In my case my ETLs were usually once daily and the fact that they took 1 minute instead of 1 second was not a huge deal.
- michaelwda 6y agoI've also used this, combined with an agent job to keep data in sync between a primary system of record and a replica. In my case I was moving account number information between iSeries db2 and an ArcGIS instance.
- atwebb 6y agoSQL has a similar concept now called Polybase which can scale out as well.