Anh’s Status 7/20/2015 – 7/24/2015 (1 week status)
Completed section:
Work is in progress with Outbound:
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Completed ODS jobs. Austin helped with them, said that there’s remaining errors to be fixed. I’ll get to those as soon as I can.
Responded to 9-page email full of queries and questions from Analytix to move forward beginning of the week. More long emails from them since to respond to almost daily. They’ve been asking us to rerun talend jobs averaging every day this week after they’ve either overridden talend tables, or found mismatches between them. They also asked to drop talend dimension tables including all foreign keys constraints to start a fresh load. We did all what they requested. As of their status sent to us today on dimension jobs, none was fixed. Their status hasn’t changed since last week. 9 out of 14 dimension jobs still have fail status.
Completed seting up all necessary workflows for daily run and for Bryce to fill in the email notification.
Trained Bryce to get familiar with Informatica workflow manager in order to set up email notification for all informatica session in the daily workflows. He has completed staging, dimension jobs on both dev and production. He’ll continue with remaining sessions.
Not Completed section:
Work on Talend jobs so they can run on Unix by next Wed when talend license will expire.
Continue working with the Conversion team on the Informatica conversion task.
Continue supervising Bryce on his assigned tasks.
Continue with the outbound jobs.
Anh’s Status 7/13/2015 – 7/17/2015 (1 week status)
...
1) Completed fixing staging krns job
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
2) Pager duty this week.
3) Completed
. Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-671
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.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...
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 Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-656
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:
with the newest revision to the re-mapping logic: When I came back from my 1-day vacation (due to many accumulated vacation hours, use it or loose it), I was told that we hold off on this task until further direction. Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-486
6) Pager duty next week.
Anh’s Status 3/16/2015 – 3/27/2015
...