Page Comparison

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

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

Completed SBS aging ETL https://services.adcom.uci.edu/jira/browse/KFSDW-1386

Completed fixing fiscal year end problem in SMS Feed, CAFP tasks.

Started work on tasks below:

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

Fix SBS Aging task every month-end until the ODS Informatica jobs go live because Talend jobs overwrite my fixes for previous month-end from JIRA

Add to post-informatica mapping to include Valerie’s additional requirement for KBM in jira https://services.adcom.uci.edu/jira/browse/KFSDW-731

• Analytix ETL UATs: 

Completed below:

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

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

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

Worked with Analytix, Bryce on failed test cases in the fact jiras:

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

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

As soon as Analytix added missing columns fixed errors found during UATs, we need to retest them.  They’re off Tomorrow, Monday (7/29,8/1).

Additional new dimension jiras from parent jira https://services.adcom.uci.edu/jira/browse/KFSDW-1393  are ready for test but one is missing unit test script, the other doesn’t have the name of the mapping to test.  We requested Analytix to provide their missing components in the jiras below:

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

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

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

Attended weekly DSS meeting

Attended weekly meeting with Analytix

Attended weekly Change Control meeting.  I announced the next DW Annual password change for production for first group (reader)

Anh’s Status 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.

...

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

...