9/21/2015 - 10/2/2015
Completed
- Sponsored projects Informatica data loads validated against results from DWH portal.
- Cognos Framework model/package design for sponsored projects.
- Sample report tested and validated.
- Meeting prep for Office of Research data warehouse phase II.
- KC proposal sample cognos report.
- Data Date dimension table creation and Informatica ETL design.
- Informatica support for OIR.
...
- Aiding with troubleshooting/testing of Talend/Informatica conversion.
- Cognos security permissions review for Office of Research related reports.
- Communication link failure on SQL Server investigation.
- Proposed possible solution related to SynAttackProtect setting. DBA team planning on running network monitor on DB servers.
Planned
- .OR dimensional model design based on feedback from the functional teams.
9/7/2015 - 9/18/2015
Completed
...