Versions Compared

Key

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

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.

...