Is it normal when loading fact table incrementally with new data, that it can take up to one hour?
Are there any tips to have this incremental load to perform better?
Moving records from staging table to fact table
fact table is 140 million records, new load is around 500 thousand records with new timestamp
here is the execution log overview
the table is not that complex.
17 fields are moved over, from staging to fact table
1 field is from keystore
3 fields are have custom value script
table settings are..
we are running
TX, version. 6346.1
Azure database, running with 6 cpu
Best answer by danielView original