Hi team,
I am getting sales data every year, Example Shown in below table, every year last data updated in data base.
I am using 2 tier architecture , first one for Extraction and second one final Application.
How to write incremental load in this case
Product |
Year |
Month |
Sales |
Pen |
2019 |
DEC |
100 |
Eraser |
2019 |
DEC |
420 |
Pencil |
2019 |
DEC |
580 |
Pen |
2020 |
DEC |
100 |
Eraser |
2020 |
DEC |
420 |
Pencil |
2020 |
DEC |
580 |
Pen |
2021 |
DEC |
100 |
Eraser |
2021 |
DEC |
420 |
Pencil |
2021 |
DEC |
580 |