Viewing 15 posts - 181 through 195 (of 1,353 total)
One more thing:
If the report intention is to report on individual invoices, as your example indicates, than that might be better done through an OLTP system as another poster...
July 31, 2018 at 7:31 am
A couple of things here:
Not sure why you would be dissuaded from putting the data in a data warehouse. You could create the report from the operational system, but...
July 31, 2018 at 7:19 am
sorry I've wasted your time. I looked at the column definitions and the data types where different.
Is there a reason you didn't use a foreign key reference? ...
July 26, 2018 at 12:46 pm
The corporation I was working for brought this consulting firm in to create a normalized data warehouse the corporation could use. These "experts" had credentials or working...
July 25, 2018 at 8:52 am
every street has a name that is repeated, every town has... You get the idea..
Actually, I don't. For most database designs, the house/apt number + street is...
July 25, 2018 at 6:45 am
As an example, it took 36 joins just to get a customers name and address, no other information like account numbers etc!
That is NOT normalization. In...
July 25, 2018 at 5:09 am
July 24, 2018 at 9:07 am
And I think this illustrates the point Ben was trying to make in the article that it can go to far.
And my point is that this isn't normalization. ...
July 23, 2018 at 2:16 pm
I think that normalization can be taken to far. I worked for a company a few years back that was doing this very thing. I should mention...
July 23, 2018 at 1:19 pm
Take 1NF. It seems we can always divide something into even smaller units. A street address has a number, street name, and suffix such as RD, AVE,...
July 23, 2018 at 9:28 am
chances are a real database would never be perfectly in one of those
I disagree. I can show you smaller designs that are perfectly in 3NF. There is nothing...
July 23, 2018 at 9:00 am
normalize the 10 TB of data in our data warehouse just
You must not have read the last paragraph. As I stated, these rules do not apply to...
July 23, 2018 at 7:52 am
This is a scary editorial, and the preceding comments are also scary. Normalization is not some wonderful thought experiment that it can be nice to have, but it's not strictly...
July 23, 2018 at 7:03 am
I would suggest you start by creating a Net Sales 1 and a Net Sales 2, each with one half of the equation to see what's produced. Saying only a...
July 12, 2018 at 8:07 am
two different measure groups. for Actual Sales and Projected Sales
Are the really two different measure groups or two different measure in the same measure group? Have you tried...
July 12, 2018 at 7:36 am
Viewing 15 posts - 181 through 195 (of 1,353 total)