Friday, August 2, 2019

ETL two-step

When drinking up data from numerous sources to a landing database and then transforming the diversified data into a common format that lives in a second database, the landing tables should probably keep the table and column names of their sources in other systems. There are tools that will make the autodiscovery of what feeds what reverseengineerable if you don't confuse things with a name change.

No comments:

Post a Comment