Fellow programmers will feel my pain
Dec. 1st, 2009 11:07 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
pbrayWe're in the midst of a crash development project, that's being sandwiched in around November close, prep for year-end and everyone's understandable desire to take vacation days before they lose them.
The goal is to build a new subset of the corporate spend database. Last week they created a test database for this project and I've been asked to pull sample data to load into it so we can start the analysis.
- The corporate spend database model has 12 dimensions.
- The test model that they built for me has 18 dimensions. The person who built it is on vacation this week and no one can explain why we have the 6 extra dimensions, or whether or not it is safe to delete them and go back to the regular 12 dimensions.
- The SQL queries that load the corporate spend model create an output file with 42 fields (dimensions). Several of these dimensions are obvious duplicates (three different formats for department numbers, for instance) but no one can explain to me which of the 42 fields are used to load the 12 dimensions in the corporate model and which ones are ignored. The expert on this is too busy to talk to me, and the backups are... you guessed it, on vacation.
And now the project lead is IM'ing me to ask why we haven't been able to load sample data yet.
The goal is to build a new subset of the corporate spend database. Last week they created a test database for this project and I've been asked to pull sample data to load into it so we can start the analysis.
- The corporate spend database model has 12 dimensions.
- The test model that they built for me has 18 dimensions. The person who built it is on vacation this week and no one can explain why we have the 6 extra dimensions, or whether or not it is safe to delete them and go back to the regular 12 dimensions.
- The SQL queries that load the corporate spend model create an output file with 42 fields (dimensions). Several of these dimensions are obvious duplicates (three different formats for department numbers, for instance) but no one can explain to me which of the 42 fields are used to load the 12 dimensions in the corporate model and which ones are ignored. The expert on this is too busy to talk to me, and the backups are... you guessed it, on vacation.
And now the project lead is IM'ing me to ask why we haven't been able to load sample data yet.
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
(no subject)
Date: 2009-12-02 03:01 am (UTC)Just, wow.
Excuse me while I go get a beer...
(no subject)
Date: 2009-12-02 02:24 pm (UTC)I spend a lot of time, some weeks, helping other people figure out how their computers work (No, there's nothing wrong with your new word-processing software; your ASCII diacritical codes don't work because Num Lock isn't on. No, you can't make Excel do that with data you copied in from Word, but you can do it in Word, so why did you even put it in Excel in the first place? Sure, no problem, I can do your Word troubleshooting over the phone and tell you how to accept tracked changes for the fifteenth time. And so on), and every so often I toy with the idea of chucking this editing gig and becoming an IT guy (on the grounds that it might be a refreshing change, and surely the pay would be better?), but every time that happens
(no subject)
Date: 2009-12-02 03:02 pm (UTC)Yes, I'm one of those guys who thinks that they don't pay first and second level support enough considering all of the stress they go through.
That said, there are enough clueless people in IT to make me shudder. In a field that demands critical thinking and teamwork, we sure have a lack of both a lot of the time...
(no subject)
Date: 2009-12-02 03:03 pm (UTC)Coffee.... Need coffee....
(no subject)
Date: 2009-12-02 07:45 pm (UTC)(no subject)
Date: 2009-12-02 08:42 pm (UTC)(no subject)
Date: 2009-12-02 05:58 pm (UTC)Which sums up a lot of this stuff.
(no subject)
Date: 2009-12-02 06:17 pm (UTC)(no subject)
Date: 2009-12-02 07:03 pm (UTC)(no subject)
Date: 2009-12-02 07:45 pm (UTC)(no subject)
Date: 2009-12-02 08:51 pm (UTC)Fourth row down, far right column.
(no subject)
Date: 2009-12-03 03:15 am (UTC)I don't think I can get away with wearing an actual f-bomb t-shirt either at work or in front of my seven-year-old, though ...
(no subject)
Date: 2009-12-03 07:23 am (UTC)There are days when that shirt is awfully tempting, however.
(no subject)
Date: 2009-12-03 01:32 pm (UTC)(no subject)
Date: 2009-12-02 07:42 pm (UTC)