Extraction, Transformation, and Load (ETL) is the process of reformatting and moving data into the data warehouse from one or more operational systems. ETL processes are typically performed nightly so that the data is up-to-date and ready the next morning. As the size of the data warehouse increases, however, it becomes increasingly difficult to perform all of the required ETL tasks within the allocated time window. Eventually, ETL process can encroach on production time—creating downtime that results in lost productivity and opportunity costs.

You can address this problem by performing ETL only on the data that will actually be used. This way, ETL windows are not unnecessarily extended to accommodate data that will seldom or never be used in the future. DBclassify enables you to quickly and accurately identify exactly which data is needed by the data warehouse and which is not, so that only needed data is loaded. Furthermore, by reducing the amount of columns that are transferred into the data warehouse, you can reduce the cost and time of code maintenance.