Page Comparison

Anh’s Status 3/24/2016

Completed adding new columns KFS_ORG_COA_CD, KFS_ORG_CD to ods_kfs.UC_ACCOUNT_T, modifing UC_ACCOUNT_T ETL.  

Completed user acceptance test for the new rafg dimention and new changes in gl entries and balance fact tables 

Completed fixing missing fund names.  Tested and verified. 

  Fixed ODS jobs that failed due to missing synonyms on the new Oracle server, missing links to target ports, mismatched length, types.

  Replaced most mappings that needed both source and target to utilize shortcuts.

  Fixed TEM,KRIM jobs in ODS due to tables not exists so they no longer failed.

  Added additional mapping to load new tables as required such as adding [dss].[ods_kfs].[UCI_AP_PMT_RQST_EXT_T], uci_tem_airport_t to load on prod.

  Corrected from $$KBM_Owner to $$ODS_Owner for tables below: UCI_AP_PMT_RQST_EXT_T,UCI_CM_AST_ELIM_ACCT_MTRX_T,UCI_FP_GEC_ENTRY_REL_T,UCI_PDP_PMT_DTL_EXT_T

  Completed creating mapping to load uc_account_t, uc_annual_rpt_code_t to run on dev.  Need to remove this when ready to migrate because there’s a session that load these 2 tables on production. 

  Completed converting all tables in ods_kbm

  March Month-end of the Outbound jobs:  sms feed, cafp and cafsbal loaded on production fine.  Jarrod and I verified all.  They all matched Oracle as expected. 

  Supervised Bryce. 

Anh’s Status 3/3/2016

Resolved INC0071250, INC0067892

...

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

...