Develop PB AR Transaction Data Mart

Domokin / Benchmark

PB Benchmark Project

0 stars 0 forks source link

Develop PB AR Transaction Data Mart #13

Open Domokin opened 7 years ago

Domokin commented 7 years ago

Develop ETL & Data Model for the following tables to create the PB AR Transactions Data Mart:

Data Model:

[x] PBARAgingFactX
[x] AgingBucketDimX
[x] PBFinancialClassDimX
[ ] DateDimX

ETL:

[ ] PBARAgingFactX
[x] AgingBucketDimX
[x] PBFinancialClassDimX
[ ] DateDimX

Domokin commented 7 years ago

Incident Logged: IM441377

AR Aging Clarity Load is erroring in Console with the following error:
TaskClarity - Process Clarity Altered Rows: PB AR Aging Load: Execute Clarity altered rows query for CLARITY_TDL_TRANObjectExecution Service ORA-06550: line 1, column 380: PL/SQL: ORA-00904: "CHANGES"."TX_ID": invalid identifier ORA-06550: line 1, column 201: PL/SQL: SQL Statement ignored

Domokin commented 7 years ago

Issue resolved. Change query for the CLARITY_TDL_TRAN was incorrect and has been fixed.

Domokin commented 7 years ago

Code sent to Angela for additional columns for DateDim