Oh FFS! Someone's going to get canned for this.

[mudskipper]

I'm going to bring in a support person for not noticing and either a DBA or ETL guy.

You'd built in monitoring and alerts, right?

[Sysman]

You'd built in monitoring and alerts, right?

Beat me to it.

And what about a regular review to make sure it's working as intended? Without those it's a bit like writing a backup system but not testing that the backups are readable.

[PAH]

Quick MF, delete this thread. It's one for the prosecution to piss themselves with.

[MarillionFan]

You'd built in monitoring and alerts, right?

They have a custom tool that checks for loads, monitors etc.

Everythings been working OK apart from the fact that they'd turned off SCDs on the most important dimension.

I designed the model and documented the output. ETL was outsourced.

[EternalOptimist]

actually I do sympathise with the fat one. Its the type of thing that could happen to anyone.
everyone else is to blame





and my @rse is a cream bun

[Lockhouse]

These things do happen from time to time. All you can do is explain what's happened, Don't offer your head on a block as if they want it they'll take it anyway. Most times you'll get away with it.

[MarillionFan]

These things do happen from time to time. All you can do is explain what's happened, Don't offer your head on a block as if they want it they'll take it anyway. Most times you'll get away with it.

I always get away with it. In this case I don't think there's anything to get away with. What it shows is our support end and unit testing is not up to much.

If I am in the shit:e, I always look for someone to push in front of the bus. After you EO.

[minestrone]

I would come out with some BS about not wanting to turn the audit trail on until the performance of the site was assured as the dev team were unreliable, pick up a pen and start scribbling notes on a pad until the silence forced someone else to speak, get to my desk then send in an invoice quick style.

[Pondlife]

I thought Rule #2 of being a contractor was that you never personally sign off on anything.

That's for the business to do.

[NorthWestPerm2Contr]

They have a custom tool that checks for loads, monitors etc.

Everythings been working OK apart from the fact that they'd turned off SCDs on the most important dimension.

I designed the model and documented the output. ETL was outsourced.

I would have thought you would have been able to pick up the changes in the dimension. This is the first thing I would be checking week on week as it is vital to historical reporting. I am assuming you mean by turned off SCDs that the dimension was being updated directly rather than a new row being inserted with previous rows having their end date set (SCD type 1 instead of type 2)? I can see this being the fault across the board - from the developer all the way to management.