I have an ETL job that runs fine until it gets to the step to populate the fact table. It runs for ages, without adding the new data. It used to run in 2 minutes, but I have not changed the definition of the fact table or the dimension tables referenced
in the joins.
If I copy the FROM statement from the table definition and use it to perform a SELECT COUNT(*) I get the total back in 5 seconds. There are only 1.3 million rows at present.
Does anyone have any ideas as to why the count runs so quickly yet the actual data upload seems to stall?
Thanks in advance.
View Complete Post