Page Comparison

Anh’s Status 7/29/2016 - 8/12/2016

• Completed processing special year-end for cafp, bal per Jarrod's request

dss.ods_kfs.UCI_UCOP_CAFP_ACCOUNT_T
dss.ods_kfs.UCI_UCOP_CAFP_FUND_T
dss.ods_kfs.UCI_UCOP_CFSBAL_RCRD_10 (Balance Sheet)
dss.ods_kfs.UCI_UCOP_CFSBAL_RCRD_11 (Fund Balance)
dss.ods_kfs.UCI_UCOP_CFSBAL_RCRD_20 (Revenue)
dss.ods_kfs.UCI_UCOP_CFSBAL_RCRD_30 (Expenditure Summary)
dss.ods_kfs.UCI_UCOP_CFSBAL_RCRD_31 (Expenditure Detail).

• Resolved, closed following ETL jiras:

https://services.adcom.uci.edu/jira/browse/KFSDW-1403

https://services.adcom.uci.edu/jira/browse/KFSDW-1439

https://services.adcom.uci.edu/jira/browse/KFSDW-1440

• Resolved, closed INC0107629:  Both Talend and Informatica had problem loading a record with kfs_org_ref_id  for post-doctor students.   Done fixing ETL, verified data.
• Informatica ODS deployment: 

Attended ODS deployment planning meeting.

This evening,  I turned off all ODS Talend jobs on deploy2,  unscheduled wf_m_ods_load_gec_tables (in Tammy’s folder), wf_m_ods_kfs_Temporaryload (in Bryce's folder).

• Attended Change Control meeting, announced roll out Informatica ODS this Friday.
• Analytix’s ETL UAT: Supervised Bryce, requested Analytix to fix problems found during UATs.

Anh’s Status 7/15/2016 - 7/28/2016

• Annual DW password change:  completed on dev for last group of (oper) usernames
• ETL development:

...

1) Completed fixing staging krns job

2) Pager duty this week. 

3)  Completed

     Completed setting up to schedule this job to run nightly.

4)  Emailed ddls scripts to Analytix per their request to create tables below:

...

6)  Need to schedule syncInvoiceNumberSundryDebtors to run on production

Anh’s Status 3/28/2015 – 4/10/2015

...

1)  Fixed uciSmsGIFeed.  ods_kfs.UCI_SMS_FEED_DETAIL_T table now has all records for Feb. data with batch date ’06-MAR-15’, matching Oracle side:  31,647 records, debit amount total is $3,647,165,482.52. 

...

5)  Analytix:  Provided our versions of our DBs that they asked.  They confirmed access to talenddev server.  Attended weekly status meeting this Friday morning.  They're going to send me a list of sqlsver tables so I can send them DDLs to them to create these tables.

6)  uciSmsGIFeed:  The job loaded month-end data this month without problem.  FYI -  Following day, this was the 2nd time this month that Jarrod reran, regenerated the trigger.  The job ran fine 2nd time. 

7)  Completed

• Not complete yet section: 

  1)  Staging krns job loaded all tables but Talend sent false notification.  I need to debug this job.
  2)  Export all talend jobs on new server
  3)  ACCOUNT_CG_PRPSL_NBR not being populated in dss_kfs.KFS_D_ACCOUNT

...

5)  SBSO: 

6) Pager duty next week. 

Anh’s Status 3/16/2015 – 3/27/2015

...