7/18/2016 - 7/29/2016
Completed
- OR related staging/ODS tables and Informatica ETL overhauled to be more consistent with updated DWH modeling standards.
- ETL updated to remove redundant data - certain staging session removed and changed to pull directly from source DB.
- Renamed table to be more relevant to OR users.
- Updated all SPA/KC reports to reflect new table names.
- OR Cognos reports demo/training sessions preparation
- Reviewing functionality of Workspace Advanced
- Demo reports creation per VC or Research email on data request.
- Fixed ODS session - s_m_LOAD_UCI_L
- Loading error related to KFS production deployment for table - UCI_LD_A21_PC_JOB_CD_T
- Reviewing loading error on UCI_SMS_FEED_DETAIL.
- Need to adjust mapping remove duplicate records from key columns that make up the clustered index.
...