...
- E (Extract): This step of the application downloads and extract daily files from the FTP;
- T (Transformation): This step of the application transforms the data following the relational model above;
- L (Load): This step is responsible for loading the transformed data into Impala.
The cronjob responsible for update the data warehouse everyday is running once a day in the machine 134.79.129.194.
- The code of the application responsible for running the ETL is in: /home/workspace_eclipse/PingERETL
...