Content Comparison

 Anh’s Status 5/25/2015 – 6/5/2015

Highlight: 

• Completed section:
  

  Push all kfs jobs (1 by 1) back 1 hour: 

  Jira Legacy
  server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-726

  Completed modifying unix cripts to push back as well to alert when jobs are not done. 

  Created service now ticket INC0025478 to request zena installation on informatica server so that Jarrod's app can create etl file triggers.  Update:  Jason Lin said that there's no more license.  We're replanning this task.

  Provided input to Analytix regarding ods jobs, mysql linked server.

  Resolved discrepancies in ODS jobs with Analytix. 

  Completed integrating tests for all staging jobs which took double amount of time to run.  They're fixing these so that the can complete running nightly within 1-hour window. 

  Created ldap_people,ldap_people_his under schema 'people_m' in MYSQL per Analytix's request.

  
  

• Not complete yet section: 
  Talend pager duty week 6/6 - 6/12.

  Jira Legacy
  server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-744

  
  

  Jira Legacy
  server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-727

  
  

  Jira Legacy
  server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-740

Export all talend jobs on new server

ACCOUNT_CG_PRPSL_NBR not being populated in dss_kfs.KFS_D_ACCOUNT    

Anh’s Status 5/11/2015 – 5/22/2015

...

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

...