They’re also a delight to the scientific and other communities because the range of dates (although I believe it uses the wrong calendar prior to the year 1753) has been...

I recently added audit triggers that had some degree of complexity.  To test the performance one of the developers issued a million inserts in a little over an hour--far beyond...

I prefer to use triggers.  They do have to be written carefully, but if done properly capture changes well.  Nulls are trickier to handle when updating data as they are...

I started with Kimballs 2nd edition The Data Warehouse Toolkit.  Taught me all I needed to know.

I've been doing this a long time and I haven't found anything "terrible" about it.  When I'm working with other naming conventions it can sometimes be hard to otherwise avoid...

I would not prefix a view with tbl.  In any case I rarely use views in an OLTP environment.  I do make extensive use of them in my OLAP designs...

The use of the prefixed "TBL_" is a design error so bad it has a name; it's called the tibble.

This is not a design error.  It does not violate the...

KpiId        (This is a foreign Key to another Dimension Table which explains the name of KPI in question

This is probably not right.  Each metric should have its own...

That worked.  Thanks.

Still shows I'm wrong, but no worries.  Not a big deal.

Can you fix my wrong answer? 🙂

I'm not sure about this.  It's a pretty common trigger to update the last updated date.  By default, that trigger does not cause the trigger to fire again.  Otherwise it...

@jeff Moden.  It's all  but impossible to imagine a data warehouse without a date dimension.  Not impossible though.

As you point out, the PK for a date dimension is...

I don't doubt that.  I remember my first data warehouse.  But I got my grounding by reading the Kimball books.  While I'm happy to teach my colleagues, I'm able to...

If any part of the dimension is a type 2, it's probably a 2, and only a two.  An SCD7 would be difficult to implement (it didn't even exist until...