4/11/2016 - 4/22/2016
Completed
- Kuali Coeus ODS table field additions requested by OR for proposal workflow reporting.
- Informatica ETL adjusted with additional logic.
- Cognos framework model updated.
- Cognos report adjusted with new fields.
- Compiled/executed DDLs to merge all differences between the dss and dss_kfs databases.
- Prep work for dss_kfs to dss migration.
- JIRA issues completed:
Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1255 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1256
- Code review/production deployments completed:
Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1217 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1247 - Resolved KFS_F_LEDGER_ENTRIES loading issue causing transaction duplication.
- Adjusted the mapping and converted the dss/dss_kfs database name to a variable to account for dev/prod DB name difference.
- Aiding in troubleshooting various Informatica ODS workflows issues/enhancements.
In Progress
- Troubleshooting ETL loading hanging issue.
- Currently trying to isolate the Cognos report that is causing blocking in the database.
- SPA reports specification review/discussion with OR functional staff (on-going).
- Nancy/Barbara have mentioned that the award counts may need to be adjusted to reflect distinct awards.
- Informatica SRAQ.
Planned
- Dimensions/Facts/ODS workflows load testing to dss and troubleshooting errors.
- Zena working session with Michael Story for automation of workflow failures.
- Defining relationships for all SPA system tables for the Cognos framework model (Currently waiting for documentation from Eric).
3/28/2016 - 4/8/2016
Completed
...