Oracle Joins not working
colesgaSep 13 2011 — edited Sep 13 2011Hi
I have a DW which has data loaded every hour. No code has changed but in the last two weeks we have had the same issue. The issue is that the staging table joins to all the dimension tables to get the dim keys for loading data into the fact table. What has happened twice recently is that the sql or the optimizer hasn't done the joins so that only a handful of records get loaded into the fact table. It is like oracle hasn't been able to join data from staging to matching records in the dims.
I want to know if anyone else has had this issue and what was done to fix it?
Using 4 rack node on oracle 10.2.0.3.
Cheers
Gary