Paul

If I am not mistaken, it sounds like you are attempting to put transactional event data (DW Fact Table data) into a dimension table.

The first question you must ask yourself...

Depending on the culture of the establishment, immediate termination may not be possible. Even still, I would question the competancy of Evelyn. Why would she allow this behavior...

Thank you for the fine post. I have been a DBA for a long time (more than 26 years covering mainframe, unix, and Windows). In my earlier years, hierarchical...

Oops. I forgot to add a couple of other very important differences between BI/DW and OLTP.

In some shops, ETL processing will allow separate Operational Reporting on the...

There are several models to choose from when you consider data warehousing. Some physical models are "purists" and would never conceive of having a child to a dimension table...

There is way too much to cover here in a post. It is something that experienced DBAs can hash over for weeks. But I will share a couple...