Diagrams of the ETL+ Load All, Load Replace, Load Upsert and Load Append processes.
Load All and Load Append
...
Using 1 - 3. Transmit a properly formatted query to the data source requesting relevant records and fields.
Construction the query from the (1) Source Info and (2) Extract SQL Statement, ETL+ requests a .
(3)table extraction from the Submit the query to the data source.The source (4) renders the table, which passes through ETL+ Desktop app coming through the Extract and then the Transform & Load Engines.
The Transform and Load Engine sends the source data into the (5) target database (dw) into the (6) temporary staging table to load the raw data.
Once completed, the (7) Design sends to the dw the (8) instructions to load (and transform, if applicable) the Temp Table data into the (9) target table.
...