Anh’s Status 6/8/2015 – 6/19/2015
Highlight:
Completed section:
Completed Talend pager duty week 6/6 - 6/12.
Completed
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Worked with Analytix team to resolve issues with dimension workflows. The last 3 dimension workflows are in progress: doc type, doc details, chart. Completed creating a new work flow Daily_KFS in the UCI_DIMENSION folder to set up the completed dimension workflows to run in parallel. They took less than 2 minutes on dev (less data on production). I need to verify data as soon as INC0026584 completed by DBA. Dimension workflows completed are below:
| wf_J_Dim_KF_D_ACCOUNT_Denorm1 |
| wf_J_Dim_KF_D_ACCOUNT_Denorm2 |
| wf_J_Dim_KF_D_ACCOUNT_Denorm3 |
| wf_J_Dim_KF_D_ACCOUNT_Denorm4 |
| wf_J_Dim_KF_D_ASSET_Denorm1 |
| wf_ J_Dim_KF_D_ASSET_Denorm2 |
| wf_J_Dim_KF_D_ASSET_Denorm3 |
| wf_J_Dim_KF_D_OBJECT_CODE_Denorm1 |
| wf_J_Dim_KF_D_OBJECT_CODE_Denorm2 |
| wf_ J_Dim_KF_D_VENDOR_ADDRESS |
| wf_J_Dim_KF_D_VENDOR1 |
| wf_J_Dim_KF_D_FISCAL_PERIOD_Denorm1 |
| wf_J_Dim_KF_D_BALANCE_TYPE_Denorm1 |
| wf_J_Dim_KF_D_ORG_Denorm1 |
| wf_J_Dim_KF_D_ORIGIN_Denorm1 |
| wf_J_Dim_KF_D_PROJECT_Denorm1 |
| wf_J_Dim_KF_D_ASSET_PAYMENT_Denorm1 |
| UPDATE_CURR_FLG_KF_D_FISCAL_PERIOD |
Not complete yet section:
The last 3 dimension workflows: doc type, doc details, chart.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Export all talend jobs on new server
ACCOUNT_CG_PRPSL_NBR not being populated in dss_kfs.KFS_D_ACCOUNT
Anh’s Status 5/25/2015 – 6/5/2015
...
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
...