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 05:59 pm (UTC)(no subject)
Date: 2009-12-02 07:44 pm (UTC)