Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

9/26/2016 - 10/7/2016

Completed

  • KC Negotiations module dimensions/fact ETL design
  • Discussion with Michael Story regarding implementation of Zena Informatica scheduling.
    • Informatica app server configuration changed to allow for batch scripting for scheduling.
    • Currently waiting for de-allocation of existing Zena client license.
    • Script for command prompt workflow execution sent to Michael.
  • Informatica overview presentation slides for brown bag session.
  • JIRA issues completed:
    • Jira Legacy
      serverOIT JIRA
      columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
      serverId252346bd-c418-34af-94a0-0709b2108812
      keyKFSDW-1467
    • Jira Legacy
      serverOIT JIRA
      columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
      serverId252346bd-c418-34af-94a0-0709b2108812
      keyKFSDW-1478
    • Jira Legacy
      serverOIT JIRA
      columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
      serverId252346bd-c418-34af-94a0-0709b2108812
      keyKFSDW-1497
    • Jira Legacy
      serverOIT JIRA
      columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
      serverId252346bd-c418-34af-94a0-0709b2108812
      keyKFSDW-1511

In Progress 

  • Troubleshooting/fixing new development by Analytix for KFS data mart additions.
    • PO
    • Disbursement
  • Sponsor category code reconciliation for SPA reports.
  • KC Negotiations module dimensional model Cognos Framework design.
    • Sample Cognos reports design as POC for OR functional staff.
  • Informatica PowerExchange for LDAP price quote request and purchase justification.
  • UCI staff holiday list compilation for update to the date dimension.
  • Zena Agent install on etl-dev.
    • Waiting on firewall exceptions to be completed by the security team.
  • Troubleshooting ETL performance issues from etl0 to solar.
    • Incremental fact table loading deployed to alleviate performance issues.
    • Continuing to encounter semaphore timeouts from Solar.

Planned

  • Informatica SRAQ.
    • Need to schedule meetings with security team.

 

9/12/2016 - 9/23/2016

Completed

...