Anh’s Status 6/8/2015 – 6/19/2015
...
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:
...
Completed solving fiscal year end/month end problems in outbound jobs, CAFP and CFSBAL due to duplicated records error. These jobs ran fine after that. Data matched the Oracle side.
Worked with Analytix daily to solve issues. We found out that some staging tables in Oracle kfscfg were empty or wiped out preventing them from doing their fact jobs. Tom R. copied data from stage production to dev. They had data to complete dimension and fact jobs.
Completed
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Completed
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Completed
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Completed
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Not complete yet section: The last 3 dimension workflows: doc type, doc details, chart.
Remaining fact jobs to verify: AssetFact, AssetPaymentFact, balance fact 3,4,5 (1,2 finished, matched records count between Informatica and Talend).
Need to work with DBA to restore data to dss schema. Plan for informatica jobs to run on production to test.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
|
Export all talend jobs on new server
...
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
...