[CC] (MARLO-BI) To add fields on Deliverables info Dimension

[ccastiblancoCGIAR]

Add the following fields on dim_deliverables_info key output cluster of activities

Modify the dim_deliverables_info to have the deliverables with project and the supplementary

• [x] Modify the table scripts for stg_deliverables_info and dim_deliverables_info
• [x] Modify the ETLs for stg_deliverables_info and dim_deliverables_info
• [x] Test in the local environment
• [ ] Execute the table scripts in production environment
• [ ] Transfered the ETLs to doppler
• [ ] Test in production environment

Deliverable: Tables and ETLs modified Move to Review when: Tested in local environment Move to Closed when: Tested in production environment

[ccastiblancoCGIAR]

table stg_deliverables_info modified in local environment:

ETL for stg_deliverables_info modified and tested in local environment:

---

[ccastiblancoCGIAR]

table: dim_deliverables_info modified

ETL for dim_deliverables_info modified and tested in local environment: