sqloracle-databasedata-warehousesql-data-warehousestar-schema-datawarehouse

What is the diff between Full table vs Delta table vs Incremental in dwh oracle


I am trying to understand the concept Full Table vs Incremental Table vs Delta table and in principle in order to simplify (faster loading process) the daily ETL loads is it a good practice to use Incremental table

FULL TABLE

INCREMENTAL TABLE

DELTA TABLE

i have read some where

Using incremental loads to move data can shorten the run times of your ETL processes and reduce the risk when something goes wrong

can some one please help me understanding the concept ?


Solution

  • As of