- Execute the created ETL for extraction of XML and generate a CSV file for PIM
- No CSV generated as testing encounter an error, check the error, it returns a communication link failure, the connection is disconnected
- Modify the ETL steps, change the directory where the XML is located
- upload the ETL in 1.175, for faster generation of the CSV as executing to my local takes longer
- Execute the created sh in 1.175 that calls the modified jobs and transfo
- encounter an error when tried to test the sh, returning an undefined directory
- modify the ETL and correct the directory
- upload the modified ETL and execute the sh for testing
- the ETL continue running and no error encounter, but when checking the CSV no CSV is created
- re-run the ETL again, there is CSV created but the CSV is blank
- run the ETL per job to check what is the cause of no data in CSV, as per checking the cause is in step 2, where the data extracted from XML is uploaded in staging but there is no data uploaded to staging table
- check the ETL why it is not inserting data in the staging table
- test and run the step 3 in my local, and it inserts data in staging table as per checking
- encounter an error in last steps inside step 3 where the for updating the table is located
- fixed the error  and execute the ETL again