[CC] (MARLO-BI) Create ETLs for CRP intersect dimension

[ccastiblancoCGIAR]

To create the ETLs for crp intersect dimension to include oicrs, policies, melias, innovations and Deliverables CRPs information.

• [x] Create queries related to each indicator and to deliverables and tested on prod environment
• [x] Create ETLs related to crps intersect dimension information
• [x] Create and modify Jobs related to crp intersect dimension process
• [x] Test ETLs on local environment.
• [x] Copy ETLs on Doppler and testing the execution

Deliverable: ETLs and job created and modified Move to Review when: ETLs tested on local environment Move to Closed when: ETLs tested on Doppler .

[ccastiblancoCGIAR]

Queries for each indicator and crp many to many relationship, created and tested in local environment.

ETL for stg_pre_group_crps created and tested in Local environment.

OICRs and MELIAs:

Policies:

Innovations:

Deliverables:

[ccastiblancoCGIAR]

ETL for stg_intersect_group_crps, created and tested in local environment.

[ccastiblancoCGIAR]

ETL for dim_intersect_group_crps, created and tested in local environment.

[ccastiblancoCGIAR]

ETL for stg_br_group_crps, created and tested in local environment

[ccastiblancoCGIAR]

ETL for br_group_crps, created and tested in local environment

[ccastiblancoCGIAR]

Pentaho Job dim_intersect_crps_process, created and tested in local environment.

Pentaho Job 03_intersect_dimensions_process modify to add the previous job to the process.

[ccastiblancoCGIAR]

ETLs and jobs transferred to Doppler and executed in production environment.