Page Comparison

Anh’s Status 4/11/2016 - 4/22/2016

• Outbound month end:  Found duplicate records in cafp (duplicated centr_seq_nbr),stf100(duplicated ID).  I created a jira for the problem: https://services.adcom.uci.edu/jira/browse/KFSDW-1242
• SBS task:  Completed fixing wrong types in the sbs againgreport tables.   Its jira is  https://services.adcom.uci.edu/jira/browse/KFSDW-1243
    Next, Jarrod and I set up the trigger from zena to create trigger file to informatica server to load these tables.   
• Account Dimension: Completed  UAT for https://services.adcom.uci.edu/jira/browse/KFSDW-1216 (Modify ETL to populate ACCOUNT_SUB_FUND_CD on Account Dim from UC_FUND_T). 
• ODS: Completed https://services.adcom.uci.edu/jira/browse/DWH-1801 (Add new columns to existing mapping in ODS due to Warren's recent additional changes in Oracle)
• Cleaning up tables (infor, talend) that are no longer needed in our databases in lunar, solar.  For the same purpose, I created now ticket INC0084270 for the DBA team to remove stage_kfs_infor.  Today this ticket is resolved, closed.
• Analytix task:  
         Completed UAT for the pending entries fact task.
         Attended meeting with Analytix on the KFS Purchase Order.
         On-going with the UATs.
• Supervised Bryce.

Anh’s Status 3/25/2016 - 4/8/2016

...

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

...