| From: | Anthony Apollis <anthony(dot)apollis(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Destination Table - Condition Amount 0 |
| Date: | 2024-08-08 16:35:00 |
| Message-ID: | CAJyMCYJ9GJvJoY9MGvzyf-gO9ZnAwVrZSgrPfn0dGaChdb93HA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I need your assistance with an ETL process that runs every six months.
Currently, we are in Calendar Year/FY 2025, which started in July 2024.
The issue is with the "Condition Amount" for FY 2025. Data comes through
correctly until the "Insert Data Into Task" step (please see the attached
screenshot). However, it appears that the code responsible for the "Update
PD Credit" step is not functioning as expected.
[image: image.png]
The destination table [Turkey - NCD Revenue Reporting Model_Table_Model] is
receiving data for FY 2025, but the "*Condition Amount*" column contains
zeros for 2025. Please see the attached sample data for reference.
To help diagnose the issue, I have included the following:
DDL for all three tables.
Insert/Update scripts for the two tasks as depicted in the screenshot above.
Sample raw data for the two tables.
SSIS can also be found attached for better understanding
Sample data for the "Insert Data Into
| Attachment | Content-Type | Size |
|---|---|---|
| POSTGRES.txt | text/plain | 9.0 KB |
| invoices raised.png | image/png | 138.5 KB |
| LEC Invoices Raised NCD.xlsx | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet | 15.8 KB |
| Key PD Movements.xlsx | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet | 13.8 KB |
| Turkey - NCD Revenue Reporting Model_Table_Model.xlsx | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet | 11.2 KB |
| Data of Both Tables Till Insert Data Into Task.xlsx | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet | 13.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2024-08-08 16:56:25 | Re: Destination Table - Condition Amount 0 |
| Previous Message | Christophe Pettus | 2024-08-08 14:11:21 | Re: Vacuum full connection exhaustion |
