|
|
|
|
|
by technofiend
2317 days ago
|
|
It saves so many headaches. I used to support a system with an automated fallback. If today's feed wasn't in by cutoff then the previous day's feed was used. Unfortunately we'd sometimes get partial or corrupted feeds. Partial feeds triggered investigation and possibly a manual rerun and corrupted ones often halted the system. Because we only used monthly numbers for reporting, delaying and rerunning any other day was pointless beyond standard root cause analysis to prevent recurrence. And this system had hundreds of feeds so at first there were almost daily issues. So I added a check to throw out any deviations over two sigma from the median of the last 30 days' good feeds which knocked out 99% of our data quality issues. I got in a boatload of trouble for different reasons but that's another story. |
|
You cannot just drop that line and walk away. Storytime?