Page Comparison

Anh’s Status 6/172016 7/4/2016 - 7/14/2016

• SBS Aging month-end

On dev: https://services.adcom.uci.edu/jira/browse/KFSDW-1282
Completed setting up triggers to load SBS aging reports.  The SBS data loaded fine.

On production:  https://services.adcom.uci.edu/jira/browse/KFSDW-1387
Fixed Talend types for aging data on production.  Valerie approved data is good.

• SMS:   Data loaded successfully for this month-end.  Jarrod will send another batch of SMS data for fiscal-year-end tomorrow.
• Informatica ODS:  On development,  Informatica ODS jobs failed due to conflict with Talend jobs.  After removing couple of talend jobs that are no longer needed to run on dev from the daily schedule, ODS jobs ran fine.
• Informatica KBM:  Done debugging, fixed problems in post Informatica sessions. 
• Analytix’s ETL UAT: Supervised Bryce to complete testing Analytix’s jiras.  They are ready for deploy:
  https://services.adcom.uci.edu/jira/browse/KFSDW-1356
  https://services.adcom.uci.edu/jira/browse/KFSDW-1357
  https://services.adcom.uci.edu/jira/browse/KFSDW-1358
  https://services.adcom.uci.edu/jira/browse/KFSDW-1360

Anh’s Status 6/17/2016 - 7/1/2016

•  DW annual password change:  Completed as scheduled.   It was successful.  HR Team was not able to see the new dss password.  I added “HR team” to share views.  They now can see it. 
• Talend didn’t load all tables in the ods_ksams. 
• ODS_KSAMS task: (Buggy) Talend didn’t load all tables in the ods_ksams.  I created informatica mappings to load them, verified data.  They were migrated to production for Cognos reports on production. 
• Completed jira https://services.adcom.uci.edu/jira/browse/KFSDW-1369
• Completed jira https://services.adcom.uci.edu/jira/browse/KFSDW-1351
• Fixed, resolved, closed https://services.adcom.uci.edu/jira/browse/KFSDW-731
• Help Cognos team to identify tables: FP_PRCRMNT_CARD_TRN_T, MCC_LIST_T. 
• Fixed UCI_LD_CSF_TRACKER_SNAPSHOT_T. 
• Fixed postinformatica mapping, session.
• Analytix’s ETL UAT: 
• https://services.adcom.uci.edu/jira/browse/KFSDW-1263 KFS_D_PO_DOC has problem, requested Analytix to fix.  They fixed their maping. 

...

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

...